Classic-Clocks.com
About Classic-Clocks.com
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM zcp_categories c, zcp_categories_description cd LEFT JOIN zcp_categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.