SELECT wpoh_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpoh_postmeta price_meta2 WHERE price_meta2.post_id=wpoh_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-08-17:2027-08-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpoh_postmeta price_meta3 WHERE price_meta3.post_id=wpoh_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpoh_posts INNER JOIN wpoh_postmeta ON ( wpoh_posts.ID = wpoh_postmeta.post_id )
WHERE 1=1 AND (
( wpoh_postmeta.meta_key = 'accommodation_location_post_id' AND wpoh_postmeta.meta_value IN ('4874') )
) AND wpoh_posts.post_type = 'accommodation' AND ((wpoh_posts.post_status = 'publish'))
GROUP BY wpoh_posts.ID HAVING 1=1
ORDER BY wpoh_posts.post_title ASC
Sogakope
Sogakope is a small town and is the capital of South Tongu district, a district in the Volta Region of Ghana. The international highway from Togo through Ghana to Ivory Coast (Côte d’Ivoire) passes through Sogakope. Very important on this route is the Lower Volta Bridge across the lower Volta River
Unfortunately no tours were found.
Unfortunately no car rentals were found.