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