Fatal error: Uncaught exception 'ErrorException' with message 'Error: 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 'GROUP BY c.category_id HAVING COUNT(*) > 0 ORDER BY LCASE(cd.name) ASC' at line 1<br />Error No: 1064<br />SELECT MAX(c.category_id) category_id, MAX(cd.name) name, MAX(c.image) image, COUNT(*) total FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_product_to_category`p2c ON c.category_id = p2c.category_id LEFT JOIN `oc_product` p ON p.product_id = p2c.product_id LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON p.product_id = p2s.product_id WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.parent_id = 17/ in /home/foto107/www/www/system/database/mysqli.php on line 41