南苑E家チェーンホテル都市一覧：

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

SELECT cityid, cityname, chain_num FROM hotel_chainnum WHERE chain_id=11 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 = 11  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 = 388 AND chain_id = 11 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 = 11 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 = 11 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 = 226 AND chain_id = 11 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 = 11 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 = 389 AND chain_id = 11 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 = 390 AND chain_id = 11 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 = 321 AND chain_id = 11 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 = 170 AND chain_id = 11 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 = 11 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 = 11 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