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 (3157,5020,5074,5021,5022,5023,5024,5025,5026,5027,5028,5060,5029,5031,5032,3060,3112,3113,3114,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,9990) AND l.location_id=1298 AND l.status='active' GROUP BY l.id ORDER BY priority DESC LIMIT 0,10

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