select villas_villa.villa_id as scriptname,title as localityname , villas_villa.website,villas_villa.tour,villas_villa.cal,villas_villa.petFriendly,villas_villa.spa, villas_villa.games,villas_villa.p1,villas_villa.p1name,villas_villa.golf, villas_villa.multiMaster,villas_villa.city,villas_villa.comm,villas_villa.locality, if(villas_villa.tour <> '','Yes','No') as ttour from villas_villa,villas_locality,villas_owns where villas_villa.city=villas_locality.localityname and villas_villa.villa_id=villas_owns.villa_id and reg_status='Active' AND locality='Central' AND multiMaster='Yes' group by villas_villa.villa_id order by villas_villa.villa_id asc , reg_status asc , reg_date asc 1030 Got error 28 from storage engine