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 'ORDER BY cd.categories_name' at line 16

SELECT c.categories_id, c.sort_order, cd.categories_name, cd.categories_description FROM categories c LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND c.categories_status = 1 WHERE cd.language_id = 2 AND c.categories_option = 1 AND c.parent_id = ORDER BY cd.categories_name

[XT SQL Error]