Location Object
(
[id] => 991129
[parent_id] => 1167
[name] => Banda Aceh
[slug] => Asia-Indonesia-Banda-Aceh.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 = 'Banda Aceh' AND locations_hotelslogue.type=5 AND status = 1 ORDER BY travel_site_count DESC, rating
Cheap Hotels in Banda Aceh, Indonesia. Compare prices on Discount Banda Aceh Hotels
