Disk full (/var/tmp/#sql_fe8_0); waiting for someone to free some space...<br /><br /><pre>
		SELECT DISTINCT c.*, cl.*
		FROM `ps_category` c
		LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3)
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE 1 AND `level_depth` <= 3
		AND (c.`active` = 1 OR c.`id_category`= 1) AND c.`onlycity` = 0
		AND (c.`onlystoretype` REGEXP '[[:<:]]1[[:>:]]' OR c.`onlystoretype` = '0')
		AND cg.`id_group` = 1
		ORDER BY c.`level_depth` ASC, cl.`name` ASC</pre>