Parakrama Samudra is a vast ancient reservoir located in Polonnaruwa, Sri Lanka. It was constructed during the reign of King Parakramabahu I in the 12th 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 ('203') )
) 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
Parakrama Samudra is a vast ancient reservoir located in Polonnaruwa, Sri Lanka. It was constructed during the reign of King Parakramabahu I in the 12th century, as part of his ambitious project to develop irrigation systems to support agriculture in the region. The name “Parakrama Samudra” translates to “The Sea of Parakrama,” reflecting its enormous size
