SELECT c.id_category, c.id_parent, cl.name FROM `eyeq_category` c INNER JOIN `eyeq_category_shop` cs ON (c.id_category = cs.id_category AND cs.id_shop="1") LEFT JOIN `eyeq_category_lang` cl ON (c.id_category = cl.id_category AND cl.id_lang="1" AND cl.id_shop="1") WHERE c.active=1 ORDER BY c.id_parent, c.position LIMIT 100