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 (hotel.HNO in (674729,676472,620396,620741,677376,653315,620653,676108,675011,675121,653117,638516,675122,677170,639525,639566,676538,620109,675142,676293,676014,677089,620805,677681,675120,675105,676361,676881,620495,675613,653522,675167,675144,676819,675127,675361,620744,675910,620591,620558,620418,675289,675201,675256,675175,632221,620458,653128,620750,676236)) AND (Region IN ('kohphangan')) ORDER BY FIELD (hotel.HNO, 674729,676472,620396,620741,677376,653315,620653,676108,675011,675121,653117,638516,675122,677170,639525,639566,676538,620109,675142,676293,676014,677089,620805,677681,675120,675105,676361,676881,620495,675613,653522,675167,675144,676819,675127,675361,620744,675910,620591,620558,620418,675289,675201,675256,675175,632221,620458,653128,620750,676236) Best of Kohphangan hotels :: Sawadee.com Thailand

    Kohphangan Hotel Reservation

    SORT BY: