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 lJg_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM lJg_postmeta price_meta2 WHERE price_meta2.post_id=lJg_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-04-25:2027-04-25' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM lJg_postmeta price_meta3 WHERE price_meta3.post_id=lJg_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM lJg_posts INNER JOIN lJg_postmeta ON ( lJg_posts.ID = lJg_postmeta.post_id )
WHERE 1=1 AND (
( lJg_postmeta.meta_key = 'accommodation_location_post_id' AND lJg_postmeta.meta_value IN ('207') )
) AND lJg_posts.post_type = 'accommodation' AND ((lJg_posts.post_status = 'publish'))
GROUP BY lJg_posts.ID HAVING 1=1
ORDER BY 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