Broadbeach Accommodation | Broadwater Accommodation | Budds Beach Accommodation | Burleigh Heads Accommodation | Coolangatta Accommodation | Currumbin Accommodation | Gold Coast Hinterland Accommodation | Helensvale Accommodation | Kirra Beach Accommodation | Main Beach Accommodation | Mermaid Beach Accommodation | Nobby Beach Accommodation | Palm Beach Accommodation | Rainbow Bay Accommodation | Sorrento Accommodation | Southport Accommodation | Surfers Paradise Accommodation | Tamborine Mountain Accommodation | Wongawallan Accommodation
|
Need Assistance? |
Holiday In Australia Australia Accomodation ApartmentsHoliday In Australia Booktoday Australia Accomodation ApartmentsFeatured AccommodationThere is error in the sql query SELECT * FROM `hotel` INNER JOIN `featured` ON `hotel`.`hotelID`=`featured`.`featuredHotelID` INNER JOIN location ON hotel.hotelLocation=location.locationID WHERE `featured`.`featuredExpiry` >= '2012-01-28' AND `featured`.`featuredCurrent` = 1 AND `featured`.`featuredLocationID` = `hotel`.`hotelLocation` AND `hotel`.`hotelCurrent` = 1 AND (hotelLocation = ) AND locationCurrent = '1' ORDER BY `hotel`.`hotelRating` DESC,`hotel`.`hotelName` ASC |