Query SELECT * FROM (  SELECT t.*, g.filename FROM tree_hu t LEFT JOIN gallery_images g ON g.gallery_id=t.gallery_id AND g.active=1 WHERE (t.visible=1) AND ((type=1 AND w_pozicio>0) OR type=4 OR type=3) ORDER BY g.order_by) dertab GROUP BY code failedDisk full (/tmp/#sql-temptable-460-32b2cd-9b8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")