A fatal MySQL error occurred.

Query:
SELECT r.*, rt.rating, u.login FROM pmd_reviews r LEFT JOIN pmd_ratings rt ON r.rating_id=rt.id LEFT JOIN pmd_users u ON u.id=r.user_id WHERE r.listing_id='1105' AND status='active' GROUP BY r.id ORDER BY id DESC

Error:
(1021) Disk full (/tmp/#sql_5127_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")