An Error Was Encountered
Error Number: 1064
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 ' id DESC LIMIT 0, 16' at line 11
SELECT p.* FROM ( SELECT product_id FROM product_choiceinfo WHERE lft >= 19 AND rgt <= 20 AND (color_id_1 = '4' OR color_id_2 = '4' OR color_id_3 = '4') GROUP BY product_id ) AS a JOIN _en_product p ON p.id = a.product_id WHERE 1 , id DESC LIMIT 0, 16