洲際チェーンホテル都市一覧：

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

SELECT cityid, cityname, chain_num FROM hotel_chainnum WHERE chain_id=129 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 = 129  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 = 129 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 = 129 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 = 129 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 = 248 AND chain_id = 129 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 = 292 AND chain_id = 129 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 = 91 AND chain_id = 129 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 = 129 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 = 236 AND chain_id = 129 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 = 79 AND chain_id = 129 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 = 82 AND chain_id = 129 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 = 322 AND chain_id = 129 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 = 395 AND chain_id = 129 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