Real Estate - Kuantan

SELECT ads.Ad_Id,ads.Title,ads.Description,ads.Post_Date,ads.Photos,c.id AS cid,sc.id As sid,c.category_Name,sc.Sub_Category_Name,l.Location_Name FROM ad_details ads,category c , sub_category sc, location l WHERE c.id=sc.category_Id AND sc.category_Id='4' AND ads.Sub_Category_Id=sc.id AND ads.Location_Id=l.id ORDER BY ads.tmp DESC LIMIT 10
Disk full (/tmp/#sql_19a_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")