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 ') ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHE' at line 4
in:
[SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM (categories c, categories_description cd LEFT JOIN categories_description cd2) ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id='351' AND cd.categories_id='351' AND cd.language_id='2' LIMIT 1]