1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM hpcategories c, hpcategories_description cd LEFT JOIN hpcategories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id='84' AND cd.categories_id='84' AND cd.language_id='2' LIMIT 1]