MySQL returned error




Error Description :
Error No : 1055
Description : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wst_tobacco.product_category.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SQL Query
SELECT product_category.*, category.category_name AS category_category_name, category.parentcategory_id AS category_parentcategory_id FROM product_category LEFT JOIN category AS category ON(category.id=product_category.category_id) WHERE product_category.id!=0 GROUP BY category_id