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=58 AND l.location_id IN (22,41,25,255,254,250,244,251,256,64,252,253,257,42,23,27,249,264,263,29,287,260,259,258,262,283,261,282,30,43,31,44,24,33,34,45,35,215,46,36,47,214,246,278,284,290,281,277,285,247,248,319,286,305,275,288,279,38,276,289,245,48,49,39,271,270,304,274,272,265,266,269,267,268,40,273,216,51) AND l.status='active' ORDER BY priority DESC,title ASC LIMIT 0,20

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