Disk full (/tmp/#sql_1ac4b_0); waiting for someone to free some space...
SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) AND `level_depth` <= 6 AND cg.`id_group` IN (1) GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC