Ошибка DB:

Can't create/write to file '/tmp/#sql_21e3_0.MYI' (Errcode: 28 - No space left on device)

SELECT t.*, c.cat_id, count(c.id) as pcnt FROM mp_catalog as c LEFT JOIN mp_firms as f ON f.id=c.firm_id LEFT JOIN mp_tree_cats as t ON t.id=c.cat_id WHERE f.active=1 AND is_discont!=1 AND c.firm_id=120 AND c.active = 1 AND t.active=1 GROUP BY c.cat_id HAVING pcnt > 0 ORDER BY t.id