A fatal MySQL error occured.

Query:
SELECT SQL_CALC_FOUND_ROWS l.* FROM pmd_v1_listings l INNER JOIN pmd_v1_listings_categories lc ON l.id=lc.list_id WHERE lc.cat_id IN (1649,1650,1651,1652,1653) AND l.status='active' GROUP BY l.id ORDER BY priority DESC,title LIMIT 100,20

Error:
(1) Can't create/write to file '/tmp/#sql_5332_0.MYI' (Errcode: 122)