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 ')) GROUP BY variantID' at line 1
SELECT * from SC_product_options_set WHERE (productID IN ()) GROUP BY variantID