Can't execute query

SELECT p.* FROM products_eng p, categories_eng c WHERE p.cateId in () AND p.cateId = c.id AND p.available = '1' AND c.available = '1' ORDER BY p.numbered asc

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 ') AND p.cateId = c.id AND p.available = '1' AND c.available = '1' ORDER BY p.num' at line 1

This script cannot continue, terminating.