SELECT wpko_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpko_postmeta price_meta2 WHERE price_meta2.post_id=wpko_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-25:2028-02-25' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpko_postmeta price_meta3 WHERE price_meta3.post_id=wpko_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpko_posts INNER JOIN wpko_postmeta ON ( wpko_posts.ID = wpko_postmeta.post_id )
WHERE 1=1 AND (
( wpko_postmeta.meta_key = 'accommodation_location_post_id' AND wpko_postmeta.meta_value IN ('145') )
) AND wpko_posts.post_type = 'accommodation' AND ((wpko_posts.post_status = 'publish'))
GROUP BY wpko_posts.ID HAVING 1=1
ORDER BY wpko_posts.post_title ASC
Unfortunately no accommodations were found.
1 Day Nairobi National Park
7 days · 1 Country · 13 Cities
From
$
Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit.
5 Day Kashmir Tour with Pahalgam and Gulmarg
26 days · 56 Country · 150 Cities
From
$
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium.
Moroccan Cooking Class in Casablanca with Return Hotel Transfers
7 days · 1 Country · 12 Cities
From
$
Veritatis et quasi architecto beatae vitae dicta sunt explicabo perspiciatis.
Private Tailor-Made Trips – 4D/3N in Amsterdam
Country intensive tour
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
Sail Through History: Aswan to Luxor Nile Cruise
4 Days Nile Cruise
Geiranger - Ålesund - Nordkapp - Flåm - Tromsø - Geiranger
From
$
Embark on a timeless journey down the legendary Nile River. This all-inclusive 4-day, 3-night cruise from Aswan to Luxor is your private window into ancient Egypt. Sail in comfort past scenic landscapes while docking to explore magnificent temples and tombs with an expert Egyptologist guide. From the engineering marvel of the High Dam to the colossal columns of Karnak, experience the highlights of Upper Egypt in classic style, with all meals, accommodations, and guided tours seamlessly arranged.
Unfortunately no car rentals were found.