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=124 order by sort_order ASC