Disk full (/tmp/#sql_12241_0); waiting for someone to free some space...

				SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
				FROM `category` c
				LEFT JOIN `category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 6)
				LEFT JOIN `category_group` cg ON (cg.`id_category` = c.`id_category`)
				WHERE (c.`active` = 1 OR c.`id_category` = 1)
				
				AND cg.`id_group` IN (1)
				GROUP BY id_category
				ORDER BY `level_depth` ASC, c.`position` ASC