Accueil » Step 2
Sort by:
Auschwitz Package
SELECT hotel_in_city.id_hotel,hotel.info_page, hotel.stars
FROM hotel_in_city, hotel
JOIN jos_content jc ON hotel.id = jc.id_hotel
WHERE hotel_in_city.id_city = ''
AND hotel_in_city.id_hotel = hotel.id
AND hotel.active = 'yes'
AND hotel.id NOT IN(
SELECT hotel.id
FROM hotel
JOIN (tourpackages_searchdeal,hotel_searchdeal)
ON (tourpackages_searchdeal.id = hotel_searchdeal.id_pack
AND hotel_searchdeal.hotel_id = hotel.id)
WHERE ((tourpackages_searchdeal.przedzial_od >= '')
OR (tourpackages_searchdeal.przedzial_od = '0000-00-00'))
AND ((tourpackages_searchdeal.przedzial_do <= '')
OR (tourpackages_searchdeal.przedzial_do = '0000-00-00'))
AND hotel_searchdeal.id_pack = '13
AND hotel.id <> ''
ORDER BY pozycja'
)
AND hotel.id IN(
SELECT hotel.id
FROM hotel
JOIN hotel_info_page
ON (hotel_info_page.hotel_id = hotel.id)
WHERE
hotel.stars >= 0
AND hotel.stars <= 5
)
No hotels for this date. Please refine your search
Tags:
