A fatal MySQL error occurred.

Query:
SELECT c.* FROM pmd_classifieds c INNER JOIN pmd_listings l ON c.listing_id=l.id WHERE l.status='active' AND (c.expire_date > NOW() OR c.expire_date = '0000-00-00') ORDER by RAND() LIMIT 3

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