SELECT hotel.*, provinces.*, xhotels.rating, xhotels.info_en as xml FROM (hotel LEFT JOIN provinces ON hotel.province = provinces.pv_key ) LEFT JOIN xhotels ON hotel.HNO = xhotels.hno WHERE (hotel.MEMCAT='hotel') AND (hotel.Active=-1) AND (hotel.listings IN (1,3)) AND (Region IN ('samuijungleclub/')) AND (Region IN ('samui')) ORDER BY province, location, deposit6 DESC LIMIT 500 Best of Samui hotels :: Sawadee.com Thailand

    Samui Hotel Reservation

    SORT BY: