cache=SELECT
r.*,
cd.name as country_name
FROM uhb_reviews r
LEFT OUTER JOIN uhb_countries c ON cust.b_country = c.abbrv AND c.is_active = 1
LEFT OUTER JOIN uhb_countries_description cd ON c.id = cd.country_id AND cd.language_id = 'de'
WHERE r.is_active = 1
AND r.hotel_id = 104
ORDER BY RAND() ASC
Need Assistance?
Our team is 24/7 at your service to help you with your booking issues or answer any related questions
Viewed 4,540 times
