ベストウェスタンチェーンホテル都市一覧：

SELECT * FROM hotel_chain WHERE chain_id = 127 LIMIT 0,1

SELECT cityid, cityname, chain_num FROM hotel_chainnum WHERE chain_id=127 AND chain_num>0 ORDER BY chain_num DESC

SELECT a.chain_id, a.chain_num, a.cityid, a.cityname, b.chain_name, b.chain_shortname, b.picture FROM hotel_chainnum a LEFT JOIN hotel_chain b ON a.chain_id = b.chain_id WHERE a.chain_id = 127  AND a.chain_num > 0 ORDER BY a.chain_num DESC

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 321 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 383 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 385 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 386 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 59 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 233 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 388 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 54 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 58 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 192 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 145 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 108 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id, hotelname, picture, min_price, address, haoping, cityid FROM hotel_hotel WHERE Auditing = 1 AND cityid = 80 AND chain_id = 127 ORDER BY px_index DESC LIMIT 0, 4

SELECT hotel_id,hotelname,min_price,cityid FROM hotel_hotel WHERE cityid=53 ORDER BY Px_hot DESC LIMIT 0, 10