SELECT hotel.*, provinces.*, xhotels.rating, xhotels.info_cn 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 ('bangkokabout/index.html')) AND (Region IN ('bangkok')) ORDER BY province, location, deposit6 DESC LIMIT 500 Best of Bangkok hotels :: Sawadee.com Thailand

    Bangkok 预订酒店

    SORT BY: