1064 - 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 ') and status = '1'' at line 1
select products_id, specials_new_products_price from specials where products_id in () and status = '1'
