The Polonnaruwa Archaeological Site is a UNESCO World Heritage site that showcases the well-preserved ruins of the ancient city of Polonnaruwa, which served as the capital of Sri Lanka from the 11th to the 13th century
SELECT staging_lJg_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM staging_lJg_postmeta price_meta2 WHERE price_meta2.post_id=staging_lJg_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-04-28:2027-04-28' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM staging_lJg_postmeta price_meta3 WHERE price_meta3.post_id=staging_lJg_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM staging_lJg_posts INNER JOIN staging_lJg_postmeta ON ( staging_lJg_posts.ID = staging_lJg_postmeta.post_id )
WHERE 1=1 AND (
( staging_lJg_postmeta.meta_key = 'accommodation_location_post_id' AND staging_lJg_postmeta.meta_value IN ('207') )
) AND staging_lJg_posts.post_type = 'accommodation' AND ((staging_lJg_posts.post_status = 'publish'))
GROUP BY staging_lJg_posts.ID HAVING 1=1
ORDER BY staging_lJg_posts.post_title ASC
The Polonnaruwa Archaeological Site is a UNESCO World Heritage site that showcases the well-preserved ruins of the ancient city of Polonnaruwa, which served as the capital of Sri Lanka from the 11th to the 13th century. This historical site is one of the most important cultural landmarks in the country and is known for its exceptional preservation of ancient architecture and art