(pdo-pgsql): SET DATESTYLE TO ISO
(pdo-pgsql): SELECT id, country FROM countries WHERE country = 'US'
(pdo-pgsql): SELECT id FROM product WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
(pdo-pgsql): SELECT experienceenddate FROM public.product WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
(pdo-pgsql): SELECT city, region, country_code, country_name FROM user_geo_cache WHERE ip_address = '216.73.216.205'
(pdo-pgsql):
INSERT INTO user_traffic_log (id, ip_address, city, region, country_code, country_name, page_item_id, user_agent, referrer)
VALUES (
'1126ca03-7436-4c0b-840f-d3b01b713f2a',
'216.73.216.205',
'Columbus',
'Ohio',
'US',
'United States',
'aa681a33-b6a7-c776-a353-b11d215bbe20',
'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'Direct'
)
(pdo-pgsql): SELECT id, productname, price, currency, promoprice, promostartdate, promoenddate,
pricedescription, img1, productlocationcountry, productlocationtown, taggedx, bundledx,
promomoicons, featuredx, videoplaceholderimgx, logobanner, experiencestartdate,
experienceenddate, productlocationdetails, fullcountrynam, perioddetailsx,
description, maxbookingsatonce, businessowner,
event_startx, event_endx, productcategory
FROM product
WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
(pdo-pgsql): SELECT pk.id, pk.linkexperienceid6, pk.packagetypename6, pk.maxdults6, pk.maxkids6,
pk.minkidage6, pk.maxkidage6, pk.packagecostx6, pk.packagepromocost6, pk.notesx6,
pk.packagepromostartdate, pk.packagepromoenddate, pk.promomoiconspcg, pk.featuredxpcg,
pk.consumedeliverfromdate, pk.consumedelivertodate, pk.amountaddedforeigners, pk.allowkids,
pk.deductforlocalkids0to2, pk.deductforlocalkids3to6, pk.deductforlocalkid7to11,
pk.deductforlocalkid12to17, pk.deductforforeignkidsto2, pk.deductforforeignkids3to6,
pk.deductforforeignkid7to11, pk.deductforforeignkid12to17, pk.additionpack1explain,
pk.additionpack1, pk.additionpack2explain, pk.additionpack2, pk.tradeblocdiscount, pk.tradebloc,
pk.maxbookingsatonce, pk.publishx, pk.approvex,
pk.event_startx, pk.event_endx,
COALESCE(pk.stocktypex, 0) AS pk_stocktype,
COALESCE(pk.package_offerx, 0) AS pk_package_offerx,
COALESCE(pk.packagex_days_total, 0) AS pk_days_total,
COALESCE(pk.activex, 0) AS pk_activex
FROM public.packagesx pk
JOIN public.product pr ON pr.id = pk.linkexperienceid6
WHERE pk.linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
AND pk.featuredxpcg = 1
AND (
COALESCE(pk.publishx,0) = 2
OR COALESCE(pk.approvex,0) = 2
OR COALESCE(pk.activex,0) = 2
)
(pdo-pgsql): SELECT COUNT(id), SUM(stars_rated)
FROM rating_stars
WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND stars_rated > 0
GROUP BY experience_id
(pdo-pgsql):
SELECT DISTINCT
COALESCE(at.accommodationtypesx, '') AS type_name,
COALESCE(at.fontawesomexiconx, '') AS type_icon
FROM public.packagesx pk
INNER JOIN public.accommodationtypesx at
ON at.id::text = TRIM(pk.hotelbnbother)
WHERE pk.linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
AND TRIM(COALESCE(pk.hotelbnbother, '')) <> ''
AND COALESCE(pk.publishx, 0) = 2
AND COALESCE(pk.approvex, 0) = 2
AND COALESCE(pk.activex, 0) = 2
ORDER BY type_name ASC
(pdo-pgsql): SELECT COUNT(pk.id) FROM product p
JOIN packagesx pk ON p.id = pk.linkexperienceid6
WHERE CURRENT_TIMESTAMP BETWEEN pk.packagepromostartdate AND pk.packagepromoenddate
AND CURRENT_TIMESTAMP BETWEEN p.experiencestartdate AND p.experienceenddate
AND p.publishx = 2 AND p.approvex = 2
AND COALESCE(pk.publishx,0) = 2
AND COALESCE(pk.approvex,0) = 2
AND COALESCE(pk.activex,0) = 2
The Hidden Place | www.epic.africa
(pdo-pgsql): SELECT imagexfilex, text_titlex, text_bodyx
FROM public.sliderimgtextx
WHERE prod_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
(pdo-pgsql): SELECT 1
FROM public.packagesx
WHERE linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
AND COALESCE(publishx,0) = 2
AND COALESCE(approvex,0) = 2
AND COALESCE(activex,0) = 2
LIMIT 1
Nestled in the heart of Marsabit, the Hidden Place Bar offers a secluded retreat where the night sky pours down magic in starlit splendors. It's the perfect getaway for those looking to unwind in an atmosphere filled with rustic charm and the mysterious allure of Kenya’s untouched landscapes. Join us at Hidden Place Bar to enjoy a unique selection of drinks and the warm hospitality of Marsabit. Whether you're here to relax after a day of exploration or to enjoy a peaceful evening out, enjoy!
Featured Customers Feedback
(pdo-pgsql): SELECT stars_rated, comment, date_of_experience, date_of_review, name_to_display
FROM rating_stars WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
AND date_of_review >= '2025-06-04'
ORDER BY random() LIMIT 20
(pdo-pgsql): SELECT stars_rated, comment, date_of_experience, date_of_review, name_to_display
FROM rating_stars WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'
ORDER BY random() LIMIT 20
👤 Guest
Perfect
On-site: 2024 |
Review date: Aug, 2024
👤 Guest
Excellent!
On-site: 2024 |
Review date: Aug, 2024
Loading weather...
Cookie Consent
This website uses cookies to personalize content and ads, to provide social media features, and to analyze our traffic. We also share information about your use of our site with our social media, advertising, and analytics partners who may combine it with other information that you've provided to them or that they've collected from your use of their services.
Read our privacy policy.
OFFERS ALERT!
(pdo-pgsql): SELECT p.id, p.productname, p.currency, p.productlocationcountry, p.productlocationdetails, p.productlocationtown,
pk.packagecostx6, pk.packagepromocost6, pk.packagepromostartdate, pk.packagepromoenddate, pk.packagetypename6,
COALESCE(pk.package_offerx, 0) AS pk_package_offerx,
pk.event_startx, pk.event_endx, COALESCE(pk.stocktypex, 0) AS pk_stocktypex,
COALESCE(pk.hotelbnbother, '') AS pk_hotelbnbother
FROM product p JOIN packagesx pk ON p.id = pk.linkexperienceid6
WHERE CURRENT_TIMESTAMP BETWEEN pk.packagepromostartdate AND pk.packagepromoenddate
AND CURRENT_TIMESTAMP BETWEEN p.experiencestartdate AND p.experienceenddate
AND p.publishx = 2 AND p.approvex = 2
AND COALESCE(pk.publishx,0) = 2
AND COALESCE(pk.approvex,0) = 2
AND COALESCE(pk.activex,0) = 2
ORDER BY CASE WHEN productlocationcountry = 'USA' THEN 1 ELSE 2 END, RANDOM() LIMIT 50
(pdo-pgsql): SELECT id, country_list_nice_name FROM countries WHERE id = 'KEN'
(pdo-pgsql):
SELECT COALESCE(accommodationtypesx,'') AS type_name,
COALESCE(fontawesomexiconx,'') AS type_icon
FROM public.accommodationtypesx
WHERE id::text = 'fd4f54a6-eaf3-4087-8178-1f24be06d4d8'
LIMIT 1
(pdo-pgsql): SELECT id, country_list_nice_name FROM countries WHERE id = 'KEN'
(pdo-pgsql):
SELECT COALESCE(accommodationtypesx,'') AS type_name,
COALESCE(fontawesomexiconx,'') AS type_icon
FROM public.accommodationtypesx
WHERE id::text = 'c4938940-b4da-4b1a-9a67-0328f932d917'
LIMIT 1