Database error: Error writing file '/tmp/MYKGgI0e' (Errcode: 28 - No space left on device)
Query:
SELECT `CLIS`.`name`, `CLIS`.`url`, `CLIS`.`code`, `CLIS`.`id`,
 COUNT(DISTINCT(E2C.id)) AS `cnt` ,
 `CLS`.`code` AS `classifier_code` 

 FROM `entity_to_classifier` AS `E2C`
INNER JOIN `structure` AS `ES` 
	ON E2C.entity_id = ES.id
INNER JOIN `structure` AS `CLIS` 
	ON CLIS.id = E2C.classifier_item_id
INNER JOIN `structure` AS `CLS` 
	ON CLS.id = CLIS.parent
WHERE `ES`.`dtype` = 'project'
GROUP BY `CLIS`.`id`
ORDER BY `classifier_code` ASC, `CLIS`.`name` ASC