The Fish Market in Negombo, Sri Lanka, is one of the busiest and most vibrant markets in the region
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 ('1664') )
) 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
Explore Sri Lanka’s highlights in 13 days, from the beaches of Negombo to the ancient Sigiriya Rock, scenic train rides, Kandy’s culture, and Yala’s wildlife. End with a charming stay in Galle and Colombo's sights
An 11-day Sri Lanka tour with cultural sites like Sigiriya and Kandy, wildlife safaris in Yala, tea plantations in Nuwara Eliya, and relaxing beach time in Bentota. Explore Colombo before departure
The Fish Market in Negombo, Sri Lanka, is one of the busiest and most vibrant markets in the region. Located near the lagoon, it offers a wide variety of fresh seafood, including fish, crabs, prawns, and shellfish, brought in daily by local fishermen. The market is a great place to experience the local culture, with bustling stalls and vendors offering the catch of the day. It’s also a popular spot for tourists who want to get a glimpse of Sri Lanka’s fishing industry and enjoy fresh seafood.
