In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'zihesabs_thm8.Parsp_products.name_fa'; this is incompatible with sql_mode=only_full_group_by
select count(*),name_fa AS _name_sort from Parsp_products where enabled=1 AND categoryID=196 OR enabled=1 AND categoryID=198 OR enabled=1 AND categoryID=200 OR enabled=1 AND categoryID=202 OR enabled=1 AND categoryID=316 OR enabled=1 AND categoryID=318 OR enabled=1 AND categoryID=320 OR enabled=1 AND categoryID=136 OR enabled=1 AND categoryID=306 OR enabled=1 AND categoryID=308 OR enabled=1 AND categoryID=310 OR enabled=1 AND categoryID=312 OR enabled=1 AND categoryID=314 OR enabled=1 AND categoryID=132 OR enabled=1 AND categoryID=152 OR enabled=1 AND categoryID=154 OR enabled=1 AND categoryID=156 OR enabled=1 AND categoryID=158 OR enabled=1 AND categoryID=286 OR enabled=1 AND categoryID=170 OR enabled=1 AND categoryID=174 OR enabled=1 AND categoryID=176 OR enabled=1 AND categoryID=178 OR enabled=1 AND categoryID=180 OR enabled=1 AND categoryID=182 OR enabled=1 AND categoryID=184 OR enabled=1 AND categoryID=186 OR enabled=1 AND categoryID=188 OR enabled=1 AND categoryID=190 OR enabled=1 AND categoryID=324 OR ( enabled=1 AND ( productID=267 OR productID=268) ) OR ( enabled=1 AND categoryID=322 ) OR enabled=1 AND categoryID=292 OR enabled=1 AND categoryID=326 OR enabled=1 AND categoryID=140 OR enabled=1 AND categoryID=298 OR enabled=1 AND categoryID=192 OR enabled=1 AND categoryID=294 OR enabled=1 AND categoryID=296 OR enabled=1 AND categoryID=224 OR enabled=1 AND categoryID=300 OR enabled=1 AND categoryID=282 OR enabled=1 AND categoryID=302 OR enabled=1 AND categoryID=304 OR enabled=1 AND categoryID=284 OR enabled=1 AND categoryID=92 order by sort_order ASC