Can't execute query

SELECT p.id FROM products_tw p, categories_tw c WHERE p.cateId in () AND p.cateId = c.id AND p.available = '1' AND c.available = '1'  ORDER BY p.proNo 

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.pr' at line 1

This script cannot continue, terminating.