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 3
SELECT p.productID, p.Price, p.list_price, p.product_type_id, pt.tabs FROM SC_products as p LEFT JOIN SC_product_types AS pt ON p.product_type_id = pt.typeID WHERE productID IN ()