Can't execute query

SELECT p.*,c.id as cid FROM products_eng as p inner join categories_eng as c on c.id=p.cateId where p.available = '1' and c.available = '1' and p.cateId in () ORDER BY p.numbered asc LIMIT 0, 1

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 ') ORDER BY p.numbered asc LIMIT 0, 1' at line 1

This script cannot continue, terminating.