ハワード ジョンソン チェーンホテル都市一覧：

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

SELECT cityid, cityname, chain_num FROM hotel_chainnum WHERE chain_id=140 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 = 140  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 = 140 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 = 140 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 = 140 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 = 140 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 = 42 AND chain_id = 140 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 = 301 AND chain_id = 140 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 = 140 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 = 317 AND chain_id = 140 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 = 140 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 = 229 AND chain_id = 140 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 = 140 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 = 391 AND chain_id = 140 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 = 140 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 = 140 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 = 140 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