SELECT wpfa_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpfa_postmeta price_meta2 WHERE price_meta2.post_id=wpfa_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-16:2028-08-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpfa_postmeta price_meta3 WHERE price_meta3.post_id=wpfa_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpfa_posts INNER JOIN wpfa_postmeta ON ( wpfa_posts.ID = wpfa_postmeta.post_id )
WHERE 1=1 AND (
( wpfa_postmeta.meta_key = 'accommodation_location_post_id' AND wpfa_postmeta.meta_value IN ('5641') )
) AND wpfa_posts.post_type = 'accommodation' AND ((wpfa_posts.post_status = 'publish'))
GROUP BY wpfa_posts.ID HAVING 1=1
ORDER BY wpfa_posts.post_title ASC
Unfortunately no accommodations were found.
8 Days Three Guianas
Guyana • Suriname • French Guiana
From
$
Journey through three of South America's most fascinating and least-explored destinations. Discover spectacular Kaieteur Falls, colonial Paramaribo, French Guiana's historic penal colonies, the Guiana Space Centre, Indigenous communities and extraordinary tropical landscapes.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.