Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND pc.promotype = '0' AND pc.language_id = '1'' at line 1
Error No: 1064
SELECT DISTINCT sm.subscategory_id, pc.imagename, pc.name, pc.imagealtname, pc.subs_content_id, psp.* FROM ocproduct p LEFT JOIN ocproduct_subs_content pc ON (p.product_id = pc.product_id) LEFT JOIN ocproduct_subs_price psp ON (psp.subs_content_id= pc.subs_content_id AND psp.price_country='USA' AND psp.price_term='1 Year') LEFT JOIN ocsubs_master sm ON (sm.szsportcode= pc.szsportcode) WHERE sm.active=1 AND pc.product_id in () AND pc.promotype = '0' AND pc.language_id = '1'