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 p_cd.categories_id = c.parent_id ' at line 10

select distinct(c.categories_id), cd.categories_name, p_cd.categories_name as parent_name, c.parent_id from categories c, categories_description cd, categories_description p_cd where c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id='2' AND c.parent_id IN () AND p_cd.categories_id = c.parent_id order by cd.categories_name

[XT SQL Error]