Can't execute query

select * from categories_tw where available='1' and (id='STANS' or serial_code='STANS') and parentId 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 1

This script cannot continue, terminating.