Real Estate - Angeles City

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
Got error 28 from storage engine