SELECT wp12_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp12_postmeta price_meta2 WHERE price_meta2.post_id=wp12_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-02-13:2027-02-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp12_postmeta price_meta3 WHERE price_meta3.post_id=wp12_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp12_posts INNER JOIN wp12_postmeta ON ( wp12_posts.ID = wp12_postmeta.post_id )
WHERE 1=1 AND (
( wp12_postmeta.meta_key = 'accommodation_location_post_id' AND wp12_postmeta.meta_value IN ('1926') )
) AND wp12_posts.post_type = 'accommodation' AND ((wp12_posts.post_status = 'publish'))
GROUP BY wp12_posts.ID HAVING 1=1
ORDER BY wp12_posts.post_title ASC
Raybow International Hotel is arguably the most well-respected hotel in the Western region. Founded in the mid 90s, it has maintained a world-class standard in customer service and best practices in the hospitality industry, winning "best the hotel in the western region" award multiple times. This hotel really lives up to its name with over 90% of its google reviews being 4-star or above.