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 ' 100)' at line 3
SELECT optionID, option_showinprod FROM SC_category_options_showinprod WHERE categoryID IN (, 100)