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 WHERE lc.cat_id IN (10,96,99,93,97,98,104,156,94,100,101,92,109,103,105,102,95,110,164,106,107,108,163) AND l.location_id=251 AND l.status='active' GROUP BY l.id 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")