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 'uct_id=2828 ORDER BY p2c.category_id ASC' at line 1
Error No: 1064
SELECT DISTINCT p2c.category_id, cat.parent_id,cat_des.name FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_category cat ON (p2c.category_id = cat.category_id) LEFT JOIN oc_category_description cat_des ON (cat_des.category_id = cat.category_id) LEFT JOIN oc_product_to_collection p2col ON (p.product_id = p2col.product_id) WHERE p.status = '1' AND cat_des.language_id = '1' AND pd.language_id = '1' AND p2col.collection_id = 52∏uct_id=2828 ORDER BY p2c.category_id ASC