旅のおためしサイト旅モニ。旅館やホテル、飲食店・レジャー施設、温泉が無料で当たる旅行モニター募集。

旅のおためしサイト

岐阜県 / 飛騨北部2013.07.03~

宿泊
新鮮な風味と深い滋味の絶品飛騨牛をとことん堪能♪「飛騨牛会席」で贅沢気分

飛騨高山の観光を楽しんで宿に着いたら、まずはお風呂。山々を望む天望風呂もよし、畳敷きの浮世風呂もよし、個性的な浴場で良質の温泉を心ゆくまで楽しみたい。夕食のメインとなる飛騨牛は、さっぱりしていながらも旨みが豊かで、柔らかさが特徴の上質の肉。飛騨牛の鍋物、寿司などの料理で、飛騨牛を味わい尽くそう。

旅モニポイント

旅モニポイント

ひだホテルプラザで、一番人気のプランです。皆様のご応募をお待ちしております。

ひだホテルプラザ より

モニタープラン

ひだホテルプラザ

プラン概要プラン概要
【1泊2食付】●夕食:肉質、味ともに絶品の飛騨牛を使った「飛騨牛会席」を、和食処のレストランでいただけるプラン●部屋:指定なし●プラン特典:みたらし団子1名様、1本付き(小学校高学年以上)、ホテル売店の10%割引券付き(対象除外品あり)、高山市内/観光文化施設割引券付き、チェックイン前・アウト後の自家用車お預かりOK
応募期間応募期間
2013年07月03日~2013年07月09日まで
募集人数募集人数
1 組 2 名様
※規定以外の人数でご参加された場合、モニター体験をお断りさせていただきます。
応募条件応募条件
●当選の際、ご自身の携帯電話番号の登録が可能な方●旅マルシェ会員に登録いただいた方●各宿の指定期間内に宿泊が可能な方●宿泊後モニター体験記の提出および旅モニ内での掲載、出展施設・提携メディアでの掲載を了承いただける方
モニター期間モニター期間
2013年08月01日~2013年09月30日まで
※除外日
8/10~8/17

ひだホテルプラザ ヒダホテルプラザ

高山の市内観光に便利なホテル。個性派の浴場と飛騨牛に大満足

 JR高山駅から徒歩5分。市内の観光スポットへのアクセスもよく、大きなお風呂で温泉も存分に楽しめるのがうれしい。お湯は肌にやさしい塩化物泉で、9Fにある「天望風呂」では、アルプスの山々や星空を望む展望風呂のほか、ジャグジーやミストサウナなど施設も充実している。一方、地下1Fの「浮世風呂」は、能登ヒバの漆塗りと畳敷きの床が和の情緒を演出する自慢の浴場だ。ぜひ両方入って、それぞれの雰囲気を楽しみたい。客室は洋室を中心に、和室や飛騨家具を揃えたコンセプトルームなどもあり。夕食は、和・洋・中から選ぶことができる。いずれも大自然の中で育った飛騨牛を贅沢に使用しているが、特におすすめの「飛騨牛会席」はぜひ味わってみたい。

  • シックなインテリアでまとめた空間2010年4月にリニューアルした、27㎡のスタンダード・ツイン。シモンズ社製のベッドで良質な睡眠を。
  • 見晴らしのよい天望風呂は開放感たっぷりアルプスの山々や高山の街並みを一望する屋上ジャグジー。さまざまなお風呂をはしごするのも楽しみ。
  • 高山ならではの風景も宿からすぐ近くに「古い町並み」(伝統的建造物群保存地区)へは、宿から歩いて約13分。情緒ある風景の中を散策しよう。
  • TEL
  • 住所
  • 料金
  • 交通
  • 送迎
  • 営業時間
  • 駐車場
  • 定休日
0577-33-4600
岐阜県高山市花岡町2-60
チェックイン:15:00
チェックアウト:11:00
宿泊料金:¥7,700~
■ 車でお越しの場合
高山ICより車で10分圏内
■ 公共交通機関をご利用の場合
JR高山本線高山駅より徒歩5分圏内
なし
収容数 80台
料金 無料

※この情報は2013年07月03日時点のものです。

  • TEL
  • 住所
  • 料金
  • 交通
  • 送迎
  • 営業時間
  • 駐車場
  • 定休日
(default) 30 queries took 29 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `M_Mi_banner_top`13131
2DESCRIBE `M_Mi_tabimoni`69691
3DESCRIBE `M_Ma_asomoni`64641
4DESCRIBE `M_Mt_tabemoni`64641
5DESCRIBE `M_kids`38381
6DESCRIBE `M_Sp_tieup`33331
7DESCRIBE `M_Ex_hqa_list`54541
8DESCRIBE `M_Mi_tabimoni_title`551
9DESCRIBE `M_Mi_vs_campaign`20201
10DESCRIBE `M_Or_plan_item`22221
11DESCRIBE `M_Sp_tieup_title`881
12DESCRIBE `M_MI_LinkBanner`11111
13DESCRIBE `M_Cm_feature`32321
14DESCRIBE `T_Mi_report`79792
15DESCRIBE `T_Mi_member`12121
16DESCRIBE `M_Mi_companion`440
17DESCRIBE `T_Ma_report`79791
18DESCRIBE `T_Mt_report`79792
19DESCRIBE `M_Ss_info`48481
20DESCRIBE `M_Cm_feature_genre`220
21DESCRIBE `M_Mi_election`42421
22DESCRIBE `M_Ma_election`42421
23DESCRIBE `M_Mt_election`42421
24DESCRIBE `M_Cm_feature_plan`660
25SELECT `MMiTabimoni`.`id`, `MMiTabimoni`.`hotel_id`, `MMiTabimoni`.`sub_id`, `MMiTabimoni`.`printing_s`, `MMiTabimoni`.`printing_e`, `MMiTabimoni`.`d_order`, `MMiTabimoni`.`plan_pic`, `MMiTabimoni`.`plan_name`, `MMiTabimoni`.`plan_led`, `MMiTabimoni`.`plan_outline`, `MMiTabimoni`.`plan_limit_note`, `MMiTabimoni`.`client_pic`, `MMiTabimoni`.`client_comment`, `MMiTabimoni`.`opening_s`, `MMiTabimoni`.`opening_e`, `MMiTabimoni`.`noof_group`, `MMiTabimoni`.`noof_person`, `MMiTabimoni`.`noof_person_max`, `MMiTabimoni`.`conditions`, `MMiTabimoni`.`stay_days`, `MMiTabimoni`.`stay_start`, `MMiTabimoni`.`stay_end`, `MMiTabimoni`.`stay_note`, `MMiTabimoni`.`election_day`, `MMiTabimoni`.`choice_day`, `MMiTabimoni`.`declaration_day`, `MMiTabimoni`.`dayofchoice1`, `MMiTabimoni`.`dayofchoice2`, `MMiTabimoni`.`dayofchoice3`, `MMiTabimoni`.`dayofchoice4`, `MMiTabimoni`.`dayofchoice5`, `MMiTabimoni`.`experience_day`, `MMiTabimoni`.`gohome_day`, `MMiTabimoni`.`report_day`, `MMiTabimoni`.`report_regday`, `MMiTabimoni`.`report_upday`, `MMiTabimoni`.`candidate_id`, `MMiTabimoni`.`pc_icon_url`, `MMiTabimoni`.`sp_icon_url`, `MMiTabimoni`.`pc_title_url`, `MMiTabimoni`.`sp_title_url`, `MMiTabimoni`.`editing_flag`, `MMiTabimoni`.`schedule_printing_e`, `MMiTabimoni`.`schedule_opening_e`, `MMiTabimoni`.`send_defeat_flag`, `MMiTabimoni`.`corp_banner_path_pc`, `MMiTabimoni`.`corp_banner_path_sp`, `MMiTabimoni`.`corp_banner_url`, `MMiTabimoni`.`headline`, `MMiTabimoni`.`lead`, `MMiTabimoni`.`fromhotel`, `MMiTabimoni`.`another`, `MMiTabimoni`.`comment`, `MMiTabimoni`.`pic_m`, `MMiTabimoni`.`cap_m`, `MMiTabimoni`.`pic_s1`, `MMiTabimoni`.`cap_s1`, `MMiTabimoni`.`led_s1`, `MMiTabimoni`.`pic_s2`, `MMiTabimoni`.`cap_s2`, `MMiTabimoni`.`led_s2`, `MMiTabimoni`.`pic_s3`, `MMiTabimoni`.`cap_s3`, `MMiTabimoni`.`led_s3`, `MMiTabimoni`.`site_id`, `MMiTabimoni`.`note`, `MMiTabimoni`.`og_img_pic`, `MMiTabimoni`.`monitor_privilege`, `MMiTabimoni`.`entry_privilege` FROM `M_Mi_tabimoni` AS `MMiTabimoni` WHERE `MMiTabimoni`.`id` = 201327 AND `MMiTabimoni`.`hotel_id` = 201306200006 AND `MMiTabimoni`.`sub_id` = 1 LIMIT 1110
26SELECT `MMiElection`.`id`, `MMiElection`.`institution_id`, `MMiElection`.`group_no`, `MMiElection`.`candidate_id`, `MMiElection`.`experience_day`, `MMiElection`.`reg_experience_day`, `MMiElection`.`noof_experience`, `MMiElection`.`report_day`, `MMiElection`.`report_regday`, `MMiElection`.`report_upday`, `MMiElection`.`reserve_id`, `MMiElection`.`reserve_day`, `MMiElection`.`notice_prizewinner`, `MMiElection`.`notice_deadline`, `MMiElection`.`notice_limit_deadline`, `MMiElection`.`notice_process`, `MMiElection`.`notice_rem_decision`, `MMiElection`.`notice_limit_rem_decision`, `MMiElection`.`notice_voucher`, `MMiElection`.`notice_1week`, `MMiElection`.`notice_1day`, `MMiElection`.`notice_gohome`, `MMiElection`.`notice_rem_report`, `MMiElection`.`notice_thankyou`, `MMiElection`.`mail_prizewinner`, `MMiElection`.`mail_process`, `MMiElection`.`mail_rem_decision`, `MMiElection`.`mail_voucher`, `MMiElection`.`mail_1week`, `MMiElection`.`mail_previous`, `MMiElection`.`mail_home`, `MMiElection`.`mail_unsubmitted`, `MMiElection`.`mail_thankyou`, `MMiElection`.`mail_cl_prizewinner`, `MMiElection`.`mail_cl_prizewinner_pw`, `MMiElection`.`mail_cl_voucher`, `MMiElection`.`mail_cl_voucher_pw`, `MMiElection`.`mail_cl_reminder`, `MMiElection`.`register_button`, `MMiElection`.`ticket_button`, `MMiElection`.`report_button`, `MMiElection`.`status` FROM `M_Mi_election` AS `MMiElection` WHERE `MMiElection`.`institution_id` = 201306200006 ORDER BY `MMiElection`.`report_upday` desc, `MMiElection`.`report_upday` asc LIMIT 2223
27SELECT `TMiReport`.`moni_id`, `TMiReport`.`hotel_id`, `TMiReport`.`member_id`, `TMiReport`.`contribution_day`, `TMiReport`.`hotel_name`, `TMiReport`.`sta_day`, `TMiReport`.`nickname`, `TMiReport`.`sex`, `TMiReport`.`age`, `TMiReport`.`prefectures`, `TMiReport`.`occupation`, `TMiReport`.`transportation`, `TMiReport`.`theme`, `TMiReport`.`companion_id`, `TMiReport`.`monitor_pic`, `TMiReport`.`moni_comment`, `TMiReport`.`oshi_id`, `TMiReport`.`oshi_pic`, `TMiReport`.`oshi_title`, `TMiReport`.`oshi_memo`, `TMiReport`.`whom_id`, `TMiReport`.`whom_mem`, `TMiReport`.`album1_id`, `TMiReport`.`album1_pic`, `TMiReport`.`album1_mem`, `TMiReport`.`album2_id`, `TMiReport`.`album2_pic`, `TMiReport`.`album2_mem`, `TMiReport`.`album3_id`, `TMiReport`.`album3_pic`, `TMiReport`.`album3_mem`, `TMiReport`.`album4_id`, `TMiReport`.`album4_pic`, `TMiReport`.`album4_mem`, `TMiReport`.`album5_id`, `TMiReport`.`album5_pic`, `TMiReport`.`album5_mem`, `TMiReport`.`album6_id`, `TMiReport`.`album6_pic`, `TMiReport`.`album6_mem`, `TMiReport`.`see1_pic`, `TMiReport`.`see1_name`, `TMiReport`.`see1_access`, `TMiReport`.`see1_from`, `TMiReport`.`see1_mem`, `TMiReport`.`see2_pic`, `TMiReport`.`see2_name`, `TMiReport`.`see2_access`, `TMiReport`.`see2_from`, `TMiReport`.`see2_mem`, `TMiReport`.`see3_pic`, `TMiReport`.`see3_name`, `TMiReport`.`see3_access`, `TMiReport`.`see3_from`, `TMiReport`.`see3_mem`, `TMiReport`.`location_id`, `TMiReport`.`location_god`, `TMiReport`.`location_bad`, `TMiReport`.`reception_id`, `TMiReport`.`reception_god`, `TMiReport`.`reception_bad`, `TMiReport`.`supper_id`, `TMiReport`.`supper_god`, `TMiReport`.`supper_bad`, `TMiReport`.`breakfast_id`, `TMiReport`.`breakfast_god`, `TMiReport`.`breakfast_bad`, `TMiReport`.`room_id`, `TMiReport`.`room_god`, `TMiReport`.`room_bad`, `TMiReport`.`bath_id`, `TMiReport`.`bath_god`, `TMiReport`.`bath_bad`, `TMiReport`.`inside_id`, `TMiReport`.`inside_god`, `TMiReport`.`inside_bad`, `TMiReport`.`others`, `TMiReport`.`seo_description`, `TMiReport`.`evaluation` FROM `T_Mi_report` AS `TMiReport` WHERE `TMiReport`.`moni_id` = 201410 AND `TMiReport`.`hotel_id` = 201306200006 LIMIT 1110
28SELECT `TMiReport`.`moni_id`, `TMiReport`.`hotel_id`, `TMiReport`.`member_id`, `TMiReport`.`contribution_day`, `TMiReport`.`hotel_name`, `TMiReport`.`sta_day`, `TMiReport`.`nickname`, `TMiReport`.`sex`, `TMiReport`.`age`, `TMiReport`.`prefectures`, `TMiReport`.`occupation`, `TMiReport`.`transportation`, `TMiReport`.`theme`, `TMiReport`.`companion_id`, `TMiReport`.`monitor_pic`, `TMiReport`.`moni_comment`, `TMiReport`.`oshi_id`, `TMiReport`.`oshi_pic`, `TMiReport`.`oshi_title`, `TMiReport`.`oshi_memo`, `TMiReport`.`whom_id`, `TMiReport`.`whom_mem`, `TMiReport`.`album1_id`, `TMiReport`.`album1_pic`, `TMiReport`.`album1_mem`, `TMiReport`.`album2_id`, `TMiReport`.`album2_pic`, `TMiReport`.`album2_mem`, `TMiReport`.`album3_id`, `TMiReport`.`album3_pic`, `TMiReport`.`album3_mem`, `TMiReport`.`album4_id`, `TMiReport`.`album4_pic`, `TMiReport`.`album4_mem`, `TMiReport`.`album5_id`, `TMiReport`.`album5_pic`, `TMiReport`.`album5_mem`, `TMiReport`.`album6_id`, `TMiReport`.`album6_pic`, `TMiReport`.`album6_mem`, `TMiReport`.`see1_pic`, `TMiReport`.`see1_name`, `TMiReport`.`see1_access`, `TMiReport`.`see1_from`, `TMiReport`.`see1_mem`, `TMiReport`.`see2_pic`, `TMiReport`.`see2_name`, `TMiReport`.`see2_access`, `TMiReport`.`see2_from`, `TMiReport`.`see2_mem`, `TMiReport`.`see3_pic`, `TMiReport`.`see3_name`, `TMiReport`.`see3_access`, `TMiReport`.`see3_from`, `TMiReport`.`see3_mem`, `TMiReport`.`location_id`, `TMiReport`.`location_god`, `TMiReport`.`location_bad`, `TMiReport`.`reception_id`, `TMiReport`.`reception_god`, `TMiReport`.`reception_bad`, `TMiReport`.`supper_id`, `TMiReport`.`supper_god`, `TMiReport`.`supper_bad`, `TMiReport`.`breakfast_id`, `TMiReport`.`breakfast_god`, `TMiReport`.`breakfast_bad`, `TMiReport`.`room_id`, `TMiReport`.`room_god`, `TMiReport`.`room_bad`, `TMiReport`.`bath_id`, `TMiReport`.`bath_god`, `TMiReport`.`bath_bad`, `TMiReport`.`inside_id`, `TMiReport`.`inside_god`, `TMiReport`.`inside_bad`, `TMiReport`.`others`, `TMiReport`.`seo_description`, `TMiReport`.`evaluation` FROM `T_Mi_report` AS `TMiReport` WHERE `TMiReport`.`moni_id` = 201327 AND `TMiReport`.`hotel_id` = 201306200006 LIMIT 1110
29SELECT `MSsInfo`.`area_code`, `MSsInfo`.`state_code`, `MSsInfo`.`local_code`, `MSsInfo`.`brand_id`, `MSsInfo`.`institution_id`, `MSsInfo`.`ssinfo_id`, `MSsInfo`.`disp_from`, `MSsInfo`.`disp_to`, `MSsInfo`.`headline`, `MSsInfo`.`lead`, `MSsInfo`.`pic_url1`, `MSsInfo`.`pic_url2`, `MSsInfo`.`pic_url3`, `MSsInfo`.`info`, `MSsInfo`.`ss_kind`, `MSsInfo`.`c1_code`, `MSsInfo`.`c2_code`, `MSsInfo`.`c3_code`, `MSsInfo`.`c1_code2`, `MSsInfo`.`c2_code2`, `MSsInfo`.`c3_code2`, `MSsInfo`.`c1_code3`, `MSsInfo`.`c2_code3`, `MSsInfo`.`c3_code3`, `MSsInfo`.`name`, `MSsInfo`.`tel1`, `MSsInfo`.`tel2`, `MSsInfo`.`tel3`, `MSsInfo`.`URL`, `MSsInfo`.`post_code`, `MSsInfo`.`prefectures`, `MSsInfo`.`municipality`, `MSsInfo`.`town`, `MSsInfo`.`house_number`, `MSsInfo`.`building`, `MSsInfo`.`latitude`, `MSsInfo`.`longitude`, `MSsInfo`.`open`, `MSsInfo`.`close`, `MSsInfo`.`remarks`, `MSsInfo`.`h_text`, `MSsInfo`.`h_remarks`, `MSsInfo`.`facebook`, `MSsInfo`.`price`, `MSsInfo`.`editing_flag`, `MSsInfo`.`schedule_disp_to`, `MSsInfo`.`note`, `MSsInfo`.`valid_flag` FROM `M_Ss_info` AS `MSsInfo` WHERE `MSsInfo`.`area_code` = 7 AND `MSsInfo`.`state_code` = '21' AND `MSsInfo`.`local_code` = '05' AND `MSsInfo`.`brand_id` IN (6, 7) AND `MSsInfo`.`valid_flag` = 1 AND NOT (((`MSsInfo`.`brand_id` = 1) AND (`MSsInfo`.`institution_id` = 201306200006))) 003
30SELECT `MCmFeaturePlan`.`id`, `MCmFeaturePlan`.`feature_id`, `MCmFeaturePlan`.`service_id`, `MCmFeaturePlan`.`moni_id`, `MCmFeaturePlan`.`institution_id`, `MCmFeaturePlan`.`d_order`, `MCmFeature`.`id`, `MCmFeature`.`feature_title`, `MCmFeature`.`feature_caption`, `MCmFeature`.`feature_content`, `MCmFeature`.`feature_pic`, `MCmFeature`.`feature_comment`, `MCmFeature`.`banner_url`, `MCmFeature`.`external_flag`, `MCmFeature`.`window`, `MCmFeature`.`link_url`, `MCmFeature`.`navigator_flag`, `MCmFeature`.`topics_caption1`, `MCmFeature`.`topics_content1`, `MCmFeature`.`topics_pic_url1`, `MCmFeature`.`topics_link_url1`, `MCmFeature`.`topics_genre1`, `MCmFeature`.`topics_caption2`, `MCmFeature`.`topics_content2`, `MCmFeature`.`topics_pic_url2`, `MCmFeature`.`topics_link_url2`, `MCmFeature`.`topics_genre2`, `MCmFeature`.`topics_caption3`, `MCmFeature`.`topics_content3`, `MCmFeature`.`topics_pic_url3`, `MCmFeature`.`topics_link_url3`, `MCmFeature`.`topics_genre3`, `MCmFeature`.`disp_from`, `MCmFeature`.`disp_to`, `MCmFeature`.`editing_flag`, `MCmFeature`.`schedule_disp_to`, `MCmFeature`.`created`, `MCmFeature`.`modified` FROM `M_Cm_feature_plan` AS `MCmFeaturePlan` LEFT JOIN `M_Cm_feature` AS `MCmFeature` ON (`MCmFeaturePlan`.`feature_id` = `MCmFeature`.`id`) WHERE `MCmFeaturePlan`.`service_id` = 1 AND `MCmFeaturePlan`.`moni_id` = 201327 AND `MCmFeaturePlan`.`institution_id` = 201306200006 LIMIT 1000
(marche) 44 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `M_hotel`44441
2DESCRIBE `M_duplicated_hotel`30301
3DESCRIBE `M_hotel_access`990
4DESCRIBE `M_trnkind`440
5DESCRIBE `M_startptr`440
6DESCRIBE `M_distance`440
7DESCRIBE `M_hotel_social`550
8DESCRIBE `M_leisure`54541
9DESCRIBE `M_leisure_access`990
10DESCRIBE `M_leisure_social`550
11DESCRIBE `M_restaurant`54541
12DESCRIBE `M_restaurant_access`991
13DESCRIBE `M_restaurant_social`550
14DESCRIBE `M_leisure_inf`17171
15DESCRIBE `M_hotel_inf`27271
16DESCRIBE `M_restaurant_inf`17171
17DESCRIBE `M_os_hotel`30301
18DESCRIBE `M_state`550
19DESCRIBE `M_area`440
20DESCRIBE `M_local`550
21DESCRIBE `M_age`440
22DESCRIBE `M_sex`440
23DESCRIBE `M_occupation`440
24SELECT `MDuplicatedHotel`.`hotel_id`, `MDuplicatedHotel`.`correct_hotel_id`, `MDuplicatedHotel`.`final_data_flg`, `MDuplicatedHotel`.`first_data_flg`, `MDuplicatedHotel`.`hotel_attr`, `MDuplicatedHotel`.`corp_attr`, `MDuplicatedHotel`.`corp_name`, `MDuplicatedHotel`.`hotel_name`, `MDuplicatedHotel`.`name_yomi`, `MDuplicatedHotel`.`tel1`, `MDuplicatedHotel`.`tel2`, `MDuplicatedHotel`.`tel3`, `MDuplicatedHotel`.`fax1`, `MDuplicatedHotel`.`fax2`, `MDuplicatedHotel`.`fax3`, `MDuplicatedHotel`.`URL`, `MDuplicatedHotel`.`post1`, `MDuplicatedHotel`.`post2`, `MDuplicatedHotel`.`prefectures`, `MDuplicatedHotel`.`city`, `MDuplicatedHotel`.`adress`, `MDuplicatedHotel`.`building`, `MDuplicatedHotel`.`latitude`, `MDuplicatedHotel`.`longitude`, `MDuplicatedHotel`.`area_code`, `MDuplicatedHotel`.`state_code`, `MDuplicatedHotel`.`local_code`, `MDuplicatedHotel`.`city_code`, `MDuplicatedHotel`.`town_code`, `MDuplicatedHotel`.`del_flag` FROM `M_duplicated_hotel` AS `MDuplicatedHotel` WHERE `MDuplicatedHotel`.`hotel_id` = 201306200006 LIMIT 1110
25DESCRIBE `M_hotel_mail`31311
26DESCRIBE `M_hotel_photo`27271
27DESCRIBE `M_hotel_text`991
28SELECT `MHotel`.`hotel_id`, `MHotel`.`hotel_attr`, `MHotel`.`corp_attr`, `MHotel`.`corp_name`, `MHotel`.`hotel_name`, `MHotel`.`name_yomi`, `MHotel`.`tel1`, `MHotel`.`tel2`, `MHotel`.`tel3`, `MHotel`.`fax1`, `MHotel`.`fax2`, `MHotel`.`fax3`, `MHotel`.`URL`, `MHotel`.`post1`, `MHotel`.`post2`, `MHotel`.`prefectures`, `MHotel`.`city`, `MHotel`.`adress`, `MHotel`.`building`, `MHotel`.`latitude`, `MHotel`.`longitude`, `MHotel`.`area_code`, `MHotel`.`state_code`, `MHotel`.`local_code`, `MHotel`.`city_code`, `MHotel`.`town_code`, `MHotel`.`del_flag`, `MHotel`.`note`, `MHotel`.`company_name`, `MHotel`.`company_post1`, `MHotel`.`company_post2`, `MHotel`.`company_tel1`, `MHotel`.`company_tel2`, `MHotel`.`company_tel3`, `MHotel`.`company_fax1`, `MHotel`.`company_fax2`, `MHotel`.`company_fax3`, `MHotel`.`company_prefectures`, `MHotel`.`company_municipality`, `MHotel`.`company_town`, `MHotel`.`company_house_number`, `MHotel`.`company_building`, `MHotel`.`company_url`, `MHotel`.`company_fb_url`, `MHotelInf`.`hotel_id`, `MHotelInf`.`park_stat`, `MHotelInf`.`park_lots`, `MHotelInf`.`park_charge`, `MHotelInf`.`pickup`, `MHotelInf`.`pickup_note`, `MHotelInf`.`checkin`, `MHotelInf`.`checkin_note`, `MHotelInf`.`checkout`, `MHotelInf`.`checkout_note`, `MHotelInf`.`price_note0`, `MHotelInf`.`floor_price`, `MHotelInf`.`price_note1`, `MHotelInf`.`noofrooms`, `MHotelInf`.`room_note`, `MHotelInf`.`card_id`, `MHotelInf`.`amenity_id`, `MHotelInf`.`amenity_note`, `MHotelInf`.`h_springs_id`, `MHotelInf`.`s_quality_id`, `MHotelInf`.`s_quality_note`, `MHotelInf`.`s_effect_id`, `MHotelInf`.`s_effect_note`, `MHotelInf`.`institution_id`, `MHotelInf`.`service_id`, `MHotelInf`.`location_id`, `MHotelInf`.`del_flag`, `MHotelMail`.`institution_id`, `MHotelMail`.`sales_name1`, `MHotelMail`.`sales_mail1`, `MHotelMail`.`sales_name2`, `MHotelMail`.`sales_mail2`, `MHotelMail`.`sales_name3`, `MHotelMail`.`sales_mail3`, `MHotelMail`.`sales_name4`, `MHotelMail`.`sales_mail4`, `MHotelMail`.`sales_name5`, `MHotelMail`.`sales_mail5`, `MHotelMail`.`receptionist_name1`, `MHotelMail`.`receptionist_mail1`, `MHotelMail`.`receptionist_name2`, `MHotelMail`.`receptionist_mail2`, `MHotelMail`.`receptionist_name3`, `MHotelMail`.`receptionist_mail3`, `MHotelMail`.`receptionist_name4`, `MHotelMail`.`receptionist_mail4`, `MHotelMail`.`receptionist_name5`, `MHotelMail`.`receptionist_mail5`, `MHotelMail`.`sales_tel1`, `MHotelMail`.`sales_tel2`, `MHotelMail`.`sales_tel3`, `MHotelMail`.`sales_tel4`, `MHotelMail`.`sales_tel5`, `MHotelMail`.`receptionist_tel1`, `MHotelMail`.`receptionist_tel2`, `MHotelMail`.`receptionist_tel3`, `MHotelMail`.`receptionist_tel4`, `MHotelMail`.`receptionist_tel5`, `MHotelPhoto`.`hotel_id`, `MHotelPhoto`.`sub_id`, `MHotelPhoto`.`pic_m`, `MHotelPhoto`.`cap_m`, `MHotelPhoto`.`pic_s1`, `MHotelPhoto`.`cap_s1`, `MHotelPhoto`.`led_s1`, `MHotelPhoto`.`pic_s2`, `MHotelPhoto`.`cap_s2`, `MHotelPhoto`.`led_s2`, `MHotelPhoto`.`pic_s3`, `MHotelPhoto`.`cap_s3`, `MHotelPhoto`.`led_s3`, `MHotelPhoto`.`pic_s4`, `MHotelPhoto`.`cap_s4`, `MHotelPhoto`.`led_s4`, `MHotelPhoto`.`pic_employee`, `MHotelPhoto`.`cap_employee`, `MHotelPhoto`.`pic_another`, `MHotelPhoto`.`cap_another`, `MHotelPhoto`.`pic_plan1`, `MHotelPhoto`.`cap_plan1`, `MHotelPhoto`.`pic_plan2`, `MHotelPhoto`.`cap_plan2`, `MHotelPhoto`.`pic_plan3`, `MHotelPhoto`.`cap_plan3`, `MHotelPhoto`.`del_flag`, `MHotelText`.`hotel_id`, `MHotelText`.`sub_id`, `MHotelText`.`headline`, `MHotelText`.`lead`, `MHotelText`.`fromhotel`, `MHotelText`.`another`, `MHotelText`.`comment`, `MHotelText`.`d_order`, `MHotelText`.`del_flag` FROM `M_hotel` AS `MHotel` LEFT JOIN `M_hotel_inf` AS `MHotelInf` ON (`MHotel`.`hotel_id` = `MHotelInf`.`hotel_id`) LEFT JOIN `M_hotel_mail` AS `MHotelMail` ON (`MHotel`.`hotel_id` = `MHotelMail`.`institution_id`) LEFT JOIN `M_hotel_photo` AS `MHotelPhoto` ON (`MHotel`.`hotel_id` = `MHotelPhoto`.`hotel_id` AND `MHotelPhoto`.`sub_id` = 1) LEFT JOIN `M_hotel_text` AS `MHotelText` ON (`MHotel`.`hotel_id` = `MHotelText`.`hotel_id` AND `MHotelText`.`d_order` = 1) WHERE `MHotel`.`hotel_id` = 201306200006 AND `MHotel`.`del_flag` = 0 LIMIT 1111
29SELECT `MState`.`area_code`, `MState`.`state_code`, `MState`.`state_name`, `MState`.`d_order`, `MState`.`del_flag` FROM `M_state` AS `MState` WHERE `MState`.`del_flag` = 0 ORDER BY `MState`.`area_code` asc, `MState`.`d_order` asc 47470
30SELECT `MArea`.`area_code`, `MArea`.`aria_name`, `MArea`.`d_order`, `MArea`.`del_flag` FROM `M_area` AS `MArea` WHERE `MArea`.`del_flag` = 0 ORDER BY `MArea`.`d_order` asc 12120
31SELECT `MLocal`.`area_code`, `MLocal`.`stat_code`, `MLocal`.`local_code`, `MLocal`.`local_name`, `MLocal`.`del_flag`, `MArea`.`area_code`, `MArea`.`aria_name`, `MArea`.`d_order`, `MArea`.`del_flag`, `MState`.`area_code`, `MState`.`state_code`, `MState`.`state_name`, `MState`.`d_order`, `MState`.`del_flag` FROM `M_local` AS `MLocal` LEFT JOIN `M_area` AS `MArea` ON (`MLocal`.`area_code` = `MArea`.`area_code`) LEFT JOIN `M_state` AS `MState` ON (`MLocal`.`stat_code` = `MState`.`state_code`) WHERE `MLocal`.`stat_code` = '21' AND `MLocal`.`local_code` = '05' AND `MLocal`.`del_flag` = 0 LIMIT 1110
32SELECT `MHotelAccess`.`hotel_id`, `MHotelAccess`.`startptr_id`, `MHotelAccess`.`startptr_name`, `MHotelAccess`.`trnkind_id`, `MHotelAccess`.`distance`, `MHotelAccess`.`distance_id`, `MHotelAccess`.`access_note`, `MHotelAccess`.`d_order`, `MHotelAccess`.`del_flag` FROM `M_hotel_access` AS `MHotelAccess` WHERE `MHotelAccess`.`hotel_id` = 201306200006 AND `MHotelAccess`.`startptr_id` IN (1, 3, 4, 5, 6) AND `MHotelAccess`.`trnkind_id` = 2 AND `MHotelAccess`.`del_flag` = 0 ORDER BY `d_order` ASC 110
33SELECT `MHotelAccess`.`hotel_id`, `MHotelAccess`.`startptr_id`, `MHotelAccess`.`startptr_name`, `MHotelAccess`.`trnkind_id`, `MHotelAccess`.`distance`, `MHotelAccess`.`distance_id`, `MHotelAccess`.`access_note`, `MHotelAccess`.`d_order`, `MHotelAccess`.`del_flag` FROM `M_hotel_access` AS `MHotelAccess` WHERE `MHotelAccess`.`hotel_id` = 201306200006 AND `MHotelAccess`.`del_flag` = 0 AND ((((`MHotelAccess`.`startptr_id` = 2) AND (`MHotelAccess`.`trnkind_id` IN (1, 2, 3)))) OR (((`MHotelAccess`.`startptr_id` IN (1, 3, 4, 5, 6)) AND (`MHotelAccess`.`trnkind_id` IN (1, 3))))) ORDER BY `d_order` ASC 110
34SELECT `MHotelSocial`.`hotel_id`, `MHotelSocial`.`social_id`, `MHotelSocial`.`url`, `MHotelSocial`.`d_order`, `MHotelSocial`.`del_flag` FROM `M_hotel_social` AS `MHotelSocial` WHERE `MHotelSocial`.`hotel_id` = 201306200006 AND `MHotelSocial`.`del_flag` = 0 ORDER BY `MHotelSocial`.`d_order` asc 220
35SELECT `MState`.`area_code`, `MState`.`state_code`, `MState`.`state_name`, `MState`.`d_order`, `MState`.`del_flag` FROM `M_state` AS `MState` WHERE `MState`.`del_flag` = 0 ORDER BY `MState`.`area_code` asc, `MState`.`d_order` asc 47470
36SELECT `MAge`.`id`, `MAge`.`i_name`, `MAge`.`d_order`, `MAge`.`del_flag` FROM `M_age` AS `MAge` WHERE `MAge`.`del_flag` = 0 ORDER BY `MAge`.`d_order` asc 660
37SELECT `MSex`.`id`, `MSex`.`i_name`, `MSex`.`d_order`, `MSex`.`del_flag` FROM `M_sex` AS `MSex` WHERE `MSex`.`del_flag` = 0 ORDER BY `MSex`.`d_order` asc 220
38SELECT `MOccupation`.`id`, `MOccupation`.`i_name`, `MOccupation`.`d_order`, `MOccupation`.`del_flag` FROM `M_occupation` AS `MOccupation` WHERE `MOccupation`.`del_flag` = 0 ORDER BY `MOccupation`.`d_order` asc 660
39SELECT `MTrnkind`.`id`, `MTrnkind`.`i_name`, `MTrnkind`.`d_order`, `MTrnkind`.`del_flag` FROM `M_trnkind` AS `MTrnkind` WHERE `MTrnkind`.`id` = 2 AND `MTrnkind`.`del_flag` = 0 LIMIT 1110
40SELECT `MStartptr`.`id`, `MStartptr`.`i_name`, `MStartptr`.`d_order`, `MStartptr`.`del_flag` FROM `M_startptr` AS `MStartptr` WHERE `MStartptr`.`id` = 1 AND `MStartptr`.`del_flag` = 0 LIMIT 1110
41SELECT `MDistance`.`id`, `MDistance`.`i_name`, `MDistance`.`d_order`, `MDistance`.`del_flag` FROM `M_distance` AS `MDistance` WHERE `MDistance`.`id` = 1 AND `MDistance`.`del_flag` = 0 LIMIT 1110
42SELECT `MTrnkind`.`id`, `MTrnkind`.`i_name`, `MTrnkind`.`d_order`, `MTrnkind`.`del_flag` FROM `M_trnkind` AS `MTrnkind` WHERE `MTrnkind`.`id` = 1 AND `MTrnkind`.`del_flag` = 0 LIMIT 1110
43SELECT `MStartptr`.`id`, `MStartptr`.`i_name`, `MStartptr`.`d_order`, `MStartptr`.`del_flag` FROM `M_startptr` AS `MStartptr` WHERE `MStartptr`.`id` = 2 AND `MStartptr`.`del_flag` = 0 LIMIT 1110
44SELECT `MDistance`.`id`, `MDistance`.`i_name`, `MDistance`.`d_order`, `MDistance`.`del_flag` FROM `M_distance` AS `MDistance` WHERE `MDistance`.`id` = 1 AND `MDistance`.`del_flag` = 0 LIMIT 1110
(hawaii) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `M_Haw_plan`68681
(premium) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `M_Pre_plan`44441