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-25:2027-04-25' 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 ('1669') )
) 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
Unfortunately no accommodations were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Seetha Amman Temple, located in the town of Seetha Eliya near Nuwara Eliya, Sri Lanka, is a significant Hindu temple dedicated to Goddess Sita. According to legend, this is the place where Sita was held captive by the demon king Ravana during the epic Ramayana. The temple is surrounded by stunning natural beauty, with lush greenery and views of the nearby mountains. It features intricately carved statues and is a popular pilgrimage site for Hindus, as well as a notable attraction for visitors interested in Sri Lanka’s rich cultural and mythological heritage
