SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 16) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 11 AND cl.id_shop = 16 ) WHERE `id_parent` = 17990 AND `active` = 1 AND `isIndependiente` = 0 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC1