SELECT masterlist.LocationNew, masterlist.CountryId, masterlist.RegionIDnew, regions.Region, countries.Country, masterlist.rank as myrank, masterlist.* FROM masterlist, regions, countries where (masterlist.id = 11 AND regions.RegionID=masterlist.RegionIDnew AND (countries.CountryID=masterlist.CountryId ) AND (masterlist.active = 'Y' OR masterlist.active = 'N' or masterlist.active = 'C' or masterlist.active = 'D') ) order by regions.Region, country, locationNew MTP - Visitors Conway Reef (Cevu-i-Ra)