SELECT pc.pid FROM products p , products_categories pc WHERE p.pid = pc.pid and pc.cid=63 and p.is_visible='Yes' AND pc.pid IN().mysql 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 ')' at line 7