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 c.categories_id = cd.categories_id and cd.lan' at line 4
in:
[select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.parent_id = and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status= 1 order by sort_order, cd.categories_name]