クラウンプラザチェーンホテル都市一覧：

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

SELECT cityid, cityname, chain_num FROM hotel_chainnum WHERE chain_id=118 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 = 118  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 = 118 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 = 53 AND chain_id = 118 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 = 256 AND chain_id = 118 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 = 118 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 = 384 AND chain_id = 118 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 = 118 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 = 61 AND chain_id = 118 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 = 374 AND chain_id = 118 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 = 94 AND chain_id = 118 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 = 96 AND chain_id = 118 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 = 199 AND chain_id = 118 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 = 163 AND chain_id = 118 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 = 297 AND chain_id = 118 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 = 47 AND chain_id = 118 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 = 118 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 = 394 AND chain_id = 118 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 = 118 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 = 224 AND chain_id = 118 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 = 287 AND chain_id = 118 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 = 133 AND chain_id = 118 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 = 118 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 = 50 AND chain_id = 118 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 = 343 AND chain_id = 118 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 = 118 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 = 324 AND chain_id = 118 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