CIRCUITO - Semimanillares reclinables

^ """
SELECT c.id_category, cl.name\r\n
            FROM `ps_category` c\r\n
            INNER JOIN `ps_category_lang` cl\r\n
                ON (cl.id_category = c.id_category AND cl.id_lang = 2) INNER JOIN `ps_category_shop` cs\r\n
                ON (cs.id_category = c.id_category AND cs.id_shop = 1) WHERE c.id_parent = 6\r\n
            ORDER BY c.position ASC, cl.name ASC
"""

^ 1

^ 2