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

    Chachoengsao 预订酒店

    SORT BY: