気仙沼市総合体育館

最寄駅
JR気仙沼線/南気仙沼から30分   同じ路線
その他の交通手段
南気仙沼駅から2.5km程度
住所
宮城県気仙沼市赤岩牧沢44−180   近くの施設 経路
電話番号
運営
公営
営業時間(平日)
9:00~21:00
※休館日:月曜日※月曜が祝日の場合は火曜日
営業時間(土日祝)
9:00~21:00(土)
9:00~17:00(日祝)

料金(ビジター)
4,800∼9,700円/3-4h (全面)

予約方法

・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。
・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。
・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。
・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。
・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)
※使用料は原則として前納となります。

個人参加
無し
コート数
2
シャワー
有り
備考
気仙沼市内(1)

Whoops, looks like something went wrong.

(3/3) QueryException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and
m_fee.del_datetime = '' and
case
' at line 13 (SQL: select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select
m_fee.shop_id,
case
when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0
when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1
when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2
when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3
when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4
when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5
end as target_fee
from m_fee
where
m_fee.shop_id in () and
m_fee.del_datetime = '' and
case
when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0
when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1
when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2
when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3
when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4
when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5
end = (
select min(case
when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0
when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1
when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2
when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3
when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4
when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5
end)
from m_fee as sub_m_fee
where
sub_m_fee.shop_id in () and
sub_m_fee.del_datetime = '' and
sub_m_fee.shop_id = m_fee.shop_id

group by sub_m_fee.shop_id
)) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> 0 left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = and (`m_fee_ex`.`day_id_list` like %@1@% or `m_fee_ex`.`day_id_list` like %@2@% or `m_fee_ex`.`day_id_list` like %@3@% or `m_fee_ex`.`day_id_list` like %@4@% or `m_fee_ex`.`day_id_list` like %@5@%) and `m_fee_ex`.`stt0` <= 19 and `m_fee_ex`.`end0` >= 19 where 0 = 1 and `m_shop`.`del_login_id` = 0 group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4)

in Connection.php line 647
at Connection->runQueryCallback('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 607
at Connection->run('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 326
at Connection->select('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), true)in Builder.php line 1706
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 462
at Builder->getModels(array('*'))in Builder.php line 446
at Builder->get()in ShopService.php line 478
at ShopService->searchNearByShops(object(Shop), true)in html_shop_detail_public_service_dialog.php line 15
at html_shop_detail_public_service_dialog::createPublicServiceDialog(object(Shop))in html_shop.php line 3327
at html_shop::detail1(array('shop_id' => '1463', 'name' => '気仙沼市総合体育館', 'url' => 'http://www.k-macs.ne.jp/~k-wave/', 'url2' => '', 'mail' => 'kesennnuma@info.com', 'password' => 'futsal', 'tel' => '0266-21-3421', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '21', 'end_m' => '00', 'time_unit' => '60', 'mailto' => '0', 'shopex_id_list' => '', 'shopex_name_list' => '', 'img_title_list' => '', 'html_1_title' => '', 'html_1' => '', 'html_2_title' => '', 'html_2' => '', 'html_3_title' => '', 'html_3' => '', 'html_4_title' => '', 'html_4' => '', 'html_5_title' => '', 'html_5' => '', 'html_6_title' => '', 'html_6' => '', 'zip' => '9880171', 'pref_id' => '4', 'address1' => '気仙沼市', 'address1_kana' => 'ケセンヌマシ', 'address2' => '赤岩牧沢', 'address3' => '44−180', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11224', 'station_id' => '1122421', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '30', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '南気仙沼駅から2.5km程度', 'parking' => '', 'lng' => '141.5535619', 'lat' => '38.881653', 'distance' => '0', 'view_lat' => '38.881653', 'view_lng' => '141.5535619', 'view_heading' => '0', 'view_pitch' => '0', 'view_zoom' => '0', 'sw_lng' => '0', 'sw_lat' => '0', 'ne_lng' => '0', 'ne_lat' => '0', 'unei' => '1', 'court_cnt' => '2', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 ', 'eigyo_doniti_text' => '9:00~21:00(土) 9:00~17:00(日祝)', 'fee' => '0', 'fee_text' => '4,800∼9,700円/3-4h (全面)', 'fee_member_text' => '', 'fee_student_text' => '', 'regist_fee_text' => '', 'cancel_text' => '', 'event_cancel_text' => '', 'shower' => '1', 'old_shop_id' => '0', 'old_address' => '', 'old_created' => '', 'old_information' => '', 'view' => '0', 'public' => '0', 'freeword' => '気仙沼市総合体育館 http://www.k-macs.ne.jp/~k-wave/ kesennnuma@info.com futsal 0266-21-3421 09 00 21 00 9880171 気仙沼市 ケセンヌマシ 赤岩牧沢 44−180 南気仙沼駅から2.5km程度 9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 9:00~21:00(土) 9:00~17:00(日祝) 4,800∼9,700円/3-4h (全面) &lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt; 2020/08/26 20:54:03', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2020/08/26 20:54:03', 'upd_login_id' => '0', 'del_datetime' => null, 'del_login_id' => '0', 'non_member_visible_date' => '0', 'member_visible_date' => '0', 'tax' => null, 'shohizei' => '-1', 'is_public' => '-1', 'fee_additional_text' => '', 'only_fee_additional_text' => '', 'is_event_mail_receive' => '0', 'is_court_mail_receive' => '0', 'student_fee_condition' => '', 'is_non_member_visible' => '0', 'is_member_visible' => '0', 'visitor_customize_text' => null, 'member_customize_text' => null, 'student_customize_text' => null, 'is_blocked_fee_ex' => '0', 'can_cancel' => '0', 'is_installed_web_reservation_button' => '0', 'show_price_in_reservation' => '0', 'use_fee_2' => '0', 'use_fee_3' => '0', 'use_fee_4' => '0', 'fee_4_text' => null, 'fee_4_condition' => '', 'can_event_entry' => '-1', 'is_linked_with_fee' => '0', 'eigyo_heijitu_text_linked_with_fee' => '', 'eigyo_doniti_text_linked_with_fee' => '', 'court_cnt_linked_with_court' => '0', 'fee_text_linked_with_fee' => '', 'fee_member_text_linked_with_fee' => '', 'fee_student_text_linked_with_fee' => '', 'reservation_method' => '&lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt;', 'fee_fee_4_text' => '', 'is_installed_reservation_button' => '0', 'pref_name' => '宮城県', 'station_name' => '南気仙沼', 'line_name' => 'JR気仙沼線', 'fee_exist' => '0'))in futsal-court_detail.php line 52
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/_ima/futsal-court_detail.php')in page-program.php line 33
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/page-program.php')in template-loader.php line 74
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-includes/template-loader.php')in wp-blog-header.php line 19
at require('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-blog-header.php')in index.wp.php line 18
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/index.wp.php')in web.php line 146
at Router->{closure}('miyagi')in Route.php line 190
at Route->runCallable()in Route.php line 163
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in HttpsProtocol.php line 22
at HttpsProtocol->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 54

(2/3) PDOException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and
m_fee.del_datetime = '' and
case
' at line 13

in PDOConnection.php line 79
at PDOConnection->prepare('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4')in Connection.php line 319
at Connection->Illuminate\Database\{closure}('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0))in Connection.php line 640
at Connection->runQueryCallback('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 607
at Connection->run('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 326
at Connection->select('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), true)in Builder.php line 1706
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 462
at Builder->getModels(array('*'))in Builder.php line 446
at Builder->get()in ShopService.php line 478
at ShopService->searchNearByShops(object(Shop), true)in html_shop_detail_public_service_dialog.php line 15
at html_shop_detail_public_service_dialog::createPublicServiceDialog(object(Shop))in html_shop.php line 3327
at html_shop::detail1(array('shop_id' => '1463', 'name' => '気仙沼市総合体育館', 'url' => 'http://www.k-macs.ne.jp/~k-wave/', 'url2' => '', 'mail' => 'kesennnuma@info.com', 'password' => 'futsal', 'tel' => '0266-21-3421', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '21', 'end_m' => '00', 'time_unit' => '60', 'mailto' => '0', 'shopex_id_list' => '', 'shopex_name_list' => '', 'img_title_list' => '', 'html_1_title' => '', 'html_1' => '', 'html_2_title' => '', 'html_2' => '', 'html_3_title' => '', 'html_3' => '', 'html_4_title' => '', 'html_4' => '', 'html_5_title' => '', 'html_5' => '', 'html_6_title' => '', 'html_6' => '', 'zip' => '9880171', 'pref_id' => '4', 'address1' => '気仙沼市', 'address1_kana' => 'ケセンヌマシ', 'address2' => '赤岩牧沢', 'address3' => '44−180', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11224', 'station_id' => '1122421', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '30', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '南気仙沼駅から2.5km程度', 'parking' => '', 'lng' => '141.5535619', 'lat' => '38.881653', 'distance' => '0', 'view_lat' => '38.881653', 'view_lng' => '141.5535619', 'view_heading' => '0', 'view_pitch' => '0', 'view_zoom' => '0', 'sw_lng' => '0', 'sw_lat' => '0', 'ne_lng' => '0', 'ne_lat' => '0', 'unei' => '1', 'court_cnt' => '2', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 ', 'eigyo_doniti_text' => '9:00~21:00(土) 9:00~17:00(日祝)', 'fee' => '0', 'fee_text' => '4,800∼9,700円/3-4h (全面)', 'fee_member_text' => '', 'fee_student_text' => '', 'regist_fee_text' => '', 'cancel_text' => '', 'event_cancel_text' => '', 'shower' => '1', 'old_shop_id' => '0', 'old_address' => '', 'old_created' => '', 'old_information' => '', 'view' => '0', 'public' => '0', 'freeword' => '気仙沼市総合体育館 http://www.k-macs.ne.jp/~k-wave/ kesennnuma@info.com futsal 0266-21-3421 09 00 21 00 9880171 気仙沼市 ケセンヌマシ 赤岩牧沢 44−180 南気仙沼駅から2.5km程度 9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 9:00~21:00(土) 9:00~17:00(日祝) 4,800∼9,700円/3-4h (全面) &lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt; 2020/08/26 20:54:03', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2020/08/26 20:54:03', 'upd_login_id' => '0', 'del_datetime' => null, 'del_login_id' => '0', 'non_member_visible_date' => '0', 'member_visible_date' => '0', 'tax' => null, 'shohizei' => '-1', 'is_public' => '-1', 'fee_additional_text' => '', 'only_fee_additional_text' => '', 'is_event_mail_receive' => '0', 'is_court_mail_receive' => '0', 'student_fee_condition' => '', 'is_non_member_visible' => '0', 'is_member_visible' => '0', 'visitor_customize_text' => null, 'member_customize_text' => null, 'student_customize_text' => null, 'is_blocked_fee_ex' => '0', 'can_cancel' => '0', 'is_installed_web_reservation_button' => '0', 'show_price_in_reservation' => '0', 'use_fee_2' => '0', 'use_fee_3' => '0', 'use_fee_4' => '0', 'fee_4_text' => null, 'fee_4_condition' => '', 'can_event_entry' => '-1', 'is_linked_with_fee' => '0', 'eigyo_heijitu_text_linked_with_fee' => '', 'eigyo_doniti_text_linked_with_fee' => '', 'court_cnt_linked_with_court' => '0', 'fee_text_linked_with_fee' => '', 'fee_member_text_linked_with_fee' => '', 'fee_student_text_linked_with_fee' => '', 'reservation_method' => '&lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt;', 'fee_fee_4_text' => '', 'is_installed_reservation_button' => '0', 'pref_name' => '宮城県', 'station_name' => '南気仙沼', 'line_name' => 'JR気仙沼線', 'fee_exist' => '0'))in futsal-court_detail.php line 52
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/_ima/futsal-court_detail.php')in page-program.php line 33
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/page-program.php')in template-loader.php line 74
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-includes/template-loader.php')in wp-blog-header.php line 19
at require('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-blog-header.php')in index.wp.php line 18
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/index.wp.php')in web.php line 146
at Router->{closure}('miyagi')in Route.php line 190
at Route->runCallable()in Route.php line 163
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in HttpsProtocol.php line 22
at HttpsProtocol->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 54

(1/3) PDOException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and
m_fee.del_datetime = '' and
case
' at line 13

in PDOConnection.php line 77
at PDO->prepare('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array())in PDOConnection.php line 77
at PDOConnection->prepare('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4')in Connection.php line 319
at Connection->Illuminate\Database\{closure}('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0))in Connection.php line 640
at Connection->runQueryCallback('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 607
at Connection->run('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), object(Closure))in Connection.php line 326
at Connection->select('select `m_shop`.*, target_fee - IFNULL(m_fee_ex.discount, 0) as target_fee from `m_shop` inner join ( select m_fee.shop_id, case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end as target_fee from m_fee where m_fee.shop_id in () and m_fee.del_datetime = \'\' and case when m_fee.stt0 <= 19 and m_fee.end0 >= 19 then m_fee.fee0 when m_fee.stt1 <= 19 and m_fee.end1 >= 19 then m_fee.fee1 when m_fee.stt2 <= 19 and m_fee.end2 >= 19 then m_fee.fee2 when m_fee.stt3 <= 19 and m_fee.end3 >= 19 then m_fee.fee3 when m_fee.stt4 <= 19 and m_fee.end4 >= 19 then m_fee.fee4 when m_fee.stt5 <= 19 and m_fee.end5 >= 19 then m_fee.fee5 end = ( select min(case when sub_m_fee.stt0 <= 19 and sub_m_fee.end0 >= 19 then sub_m_fee.fee0 when sub_m_fee.stt1 <= 19 and sub_m_fee.end1 >= 19 then sub_m_fee.fee1 when sub_m_fee.stt2 <= 19 and sub_m_fee.end2 >= 19 then sub_m_fee.fee2 when sub_m_fee.stt3 <= 19 and sub_m_fee.end3 >= 19 then sub_m_fee.fee3 when sub_m_fee.stt4 <= 19 and sub_m_fee.end4 >= 19 then sub_m_fee.fee4 when sub_m_fee.stt5 <= 19 and sub_m_fee.end5 >= 19 then sub_m_fee.fee5 end) from m_fee as sub_m_fee where sub_m_fee.shop_id in () and sub_m_fee.del_datetime = \'\' and sub_m_fee.shop_id = m_fee.shop_id group by sub_m_fee.shop_id )) as m_fee on `m_fee`.`shop_id` = `m_shop`.`shop_id` and `m_fee`.`target_fee` is not null and `m_fee`.`target_fee` <> ? left join `m_fee_ex` on `m_fee_ex`.`shop_id` = `m_shop`.`shop_id` and `m_fee_ex`.`del_datetime` = ? and (`m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ? or `m_fee_ex`.`day_id_list` like ?) and `m_fee_ex`.`stt0` <= ? and `m_fee_ex`.`end0` >= ? where 0 = 1 and `m_shop`.`del_login_id` = ? group by `m_shop`.`shop_id`, `target_fee`, `m_fee_ex`.`discount` order by target_fee - IFNULL(m_fee_ex.discount, 0) limit 4', array(0, '', '%@1@%', '%@2@%', '%@3@%', '%@4@%', '%@5@%', 19, 19, 0), true)in Builder.php line 1706
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 462
at Builder->getModels(array('*'))in Builder.php line 446
at Builder->get()in ShopService.php line 478
at ShopService->searchNearByShops(object(Shop), true)in html_shop_detail_public_service_dialog.php line 15
at html_shop_detail_public_service_dialog::createPublicServiceDialog(object(Shop))in html_shop.php line 3327
at html_shop::detail1(array('shop_id' => '1463', 'name' => '気仙沼市総合体育館', 'url' => 'http://www.k-macs.ne.jp/~k-wave/', 'url2' => '', 'mail' => 'kesennnuma@info.com', 'password' => 'futsal', 'tel' => '0266-21-3421', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '21', 'end_m' => '00', 'time_unit' => '60', 'mailto' => '0', 'shopex_id_list' => '', 'shopex_name_list' => '', 'img_title_list' => '', 'html_1_title' => '', 'html_1' => '', 'html_2_title' => '', 'html_2' => '', 'html_3_title' => '', 'html_3' => '', 'html_4_title' => '', 'html_4' => '', 'html_5_title' => '', 'html_5' => '', 'html_6_title' => '', 'html_6' => '', 'zip' => '9880171', 'pref_id' => '4', 'address1' => '気仙沼市', 'address1_kana' => 'ケセンヌマシ', 'address2' => '赤岩牧沢', 'address3' => '44−180', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11224', 'station_id' => '1122421', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '30', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '南気仙沼駅から2.5km程度', 'parking' => '', 'lng' => '141.5535619', 'lat' => '38.881653', 'distance' => '0', 'view_lat' => '38.881653', 'view_lng' => '141.5535619', 'view_heading' => '0', 'view_pitch' => '0', 'view_zoom' => '0', 'sw_lng' => '0', 'sw_lat' => '0', 'ne_lng' => '0', 'ne_lat' => '0', 'unei' => '1', 'court_cnt' => '2', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 ', 'eigyo_doniti_text' => '9:00~21:00(土) 9:00~17:00(日祝)', 'fee' => '0', 'fee_text' => '4,800∼9,700円/3-4h (全面)', 'fee_member_text' => '', 'fee_student_text' => '', 'regist_fee_text' => '', 'cancel_text' => '', 'event_cancel_text' => '', 'shower' => '1', 'old_shop_id' => '0', 'old_address' => '', 'old_created' => '', 'old_information' => '', 'view' => '0', 'public' => '0', 'freeword' => '気仙沼市総合体育館 http://www.k-macs.ne.jp/~k-wave/ kesennnuma@info.com futsal 0266-21-3421 09 00 21 00 9880171 気仙沼市 ケセンヌマシ 赤岩牧沢 44−180 南気仙沼駅から2.5km程度 9:00~21:00 ※休館日:月曜日※月曜が祝日の場合は火曜日 9:00~21:00(土) 9:00~17:00(日祝) 4,800∼9,700円/3-4h (全面) &lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt; 2020/08/26 20:54:03', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2020/08/26 20:54:03', 'upd_login_id' => '0', 'del_datetime' => null, 'del_login_id' => '0', 'non_member_visible_date' => '0', 'member_visible_date' => '0', 'tax' => null, 'shohizei' => '-1', 'is_public' => '-1', 'fee_additional_text' => '', 'only_fee_additional_text' => '', 'is_event_mail_receive' => '0', 'is_court_mail_receive' => '0', 'student_fee_condition' => '', 'is_non_member_visible' => '0', 'is_member_visible' => '0', 'visitor_customize_text' => null, 'member_customize_text' => null, 'student_customize_text' => null, 'is_blocked_fee_ex' => '0', 'can_cancel' => '0', 'is_installed_web_reservation_button' => '0', 'show_price_in_reservation' => '0', 'use_fee_2' => '0', 'use_fee_3' => '0', 'use_fee_4' => '0', 'fee_4_text' => null, 'fee_4_condition' => '', 'can_event_entry' => '-1', 'is_linked_with_fee' => '0', 'eigyo_heijitu_text_linked_with_fee' => '', 'eigyo_doniti_text_linked_with_fee' => '', 'court_cnt_linked_with_court' => '0', 'fee_text_linked_with_fee' => '', 'fee_member_text_linked_with_fee' => '', 'fee_student_text_linked_with_fee' => '', 'reservation_method' => '&lt;p&gt;・使用を希望する日の空き状況を、窓口または電話にて確認し、空いていれば団体による貸切予約ができます。&lt;br /&gt;・団体利用の申請が行えるのは、使用を希望する日の6ヶ月前から7日前までの期間です。&lt;br /&gt;・団体の申請をする場合は、使用についての事前打ち合わせを行ってください。&lt;br /&gt;・利用するときは、気仙沼市総合体育館使用許可申請書に必要事項を記入し、承認を受ける必要があります。&lt;br /&gt;・施設使用料は、申請書提出の際に納入してください。(施設使用料の他に設備使用料が加算されます。)&lt;br /&gt;※使用料は原則として前納となります。&lt;/p&gt;', 'fee_fee_4_text' => '', 'is_installed_reservation_button' => '0', 'pref_name' => '宮城県', 'station_name' => '南気仙沼', 'line_name' => 'JR気仙沼線', 'fee_exist' => '0'))in futsal-court_detail.php line 52
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/_ima/futsal-court_detail.php')in page-program.php line 33
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-content/themes/footsal_info/page-program.php')in template-loader.php line 74
at require_once('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-includes/template-loader.php')in wp-blog-header.php line 19
at require('/home/korocoo311/futsal-information.com/release/20230127173823/public/wp-blog-header.php')in index.wp.php line 18
at include('/home/korocoo311/futsal-information.com/release/20230127173823/public/index.wp.php')in web.php line 146
at Router->{closure}('miyagi')in Route.php line 190
at Route->runCallable()in Route.php line 163
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in HttpsProtocol.php line 22
at HttpsProtocol->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 54