A fatal MySQL error occurred.

Query:
SELECT SQL_CALC_FOUND_ROWS l.* FROM pmd_listings l INNER JOIN pmd_listings_categories lc ON l.id=lc.list_id INNER JOIN pmd_locations loc ON l.location_id=loc.id WHERE lc.cat_id=135 AND l.location_id IN (65,81,83,92,93,101,110,119,126,127,132,143,151,162,165,173,174,179,182,184,185,190,206,210) AND l.status='active' ORDER BY priority DESC,title ASC LIMIT 0,20

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