Home   |   Why You're Secure?   |   Cart   |   Contact Us   |   Site Map
Special offers
Privacy Notice
Conditions of Use
Contact Us
About Us

1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thisisho_tih.cd.categories_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[SELECT c.categories_id, cd.categories_name, count(ptoc.products_id) as productsId FROM products_to_categories ptoc LEFT JOIN categories c ON c.categories_id = ptoc.categories_id LEFT JOIN categories_description cd ON cd.categories_id = ptoc.categories_id WHERE ptoc.categories_id IN ( SELECT categories_id FROM categories WHERE parent_id =109 ) GROUP BY ptoc.categories_id]