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` <= 3
				AND cg.`id_group` IN (1)
				GROUP BY id_category
				ORDER BY `level_depth` ASC, c.`position` ASC