Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c30031_se_pdb.categories.parent' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and ((all_product_count > 0) or (all_product_count != 0)) order by parent' at line 1
