Location Object
(
[id] => 2382321
[parent_id] => 10296
[name] => Las Vegas
[slug] => USA-Nevada-Las-Vegas.html
[type] => 5
)
SELECT hotels.id AS id, provider_number, hotels.slug AS slug, hotels.name AS name, address1, address2, location_id, description, internet_connect,
gym, onsite_parking, pet_friendly, pool, restaurant, handicap_access, childsitting_services, bar, cable_tv,
wireless_internet_access, has_fax, iron, drycleaning, coffee_maker, airconditioning, safe, elevators, golf,
tennis, price, rating, travel_site_count.count AS travel_site_count
FROM hotels
LEFT JOIN travel_site_count ON travel_site_count.hotel_id = hotels.id
JOIN locations_hotelslogue ON hotels.location_id = locations_hotelslogue.id
WHERE locations_hotelslogue.name = 'Las Vegas' AND locations_hotelslogue.type=5 AND status = 1 ORDER BY travel_site_count DESC, rating
Cheap Hotels in Las Vegas, USA. Compare prices on Discount Las Vegas Hotels
