宮崎市北部記念体育館

最寄駅
JR日南線/宮崎から35分   同じ路線
JR宮崎空港線/宮崎から35分
住所
宮崎県宮崎市祗園1-77   近くの施設 経路
電話番号
運営
公営
営業時間(平日)
9-22時
営業時間(土日祝)
9-22時

料金(ビジター)
910円/h

予約方法

ご予約・お問い合わせ

宮崎市公共施設予約案内システム

お問い合わせ TEL.0985-28-0353

※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。
使用申込書(Excel) 使用申込書(PDF)

個人参加
無し
コート数
1
シャワー
有り
備考
宮崎市内(8)

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' => '1384', 'name' => '宮崎市北部記念体育館', 'url' => 'https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html', 'url2' => '', 'mail' => 'miyahoku@info.com', 'password' => 'futsal', 'tel' => '0985-28-0353', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '22', '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' => '8800024', 'pref_id' => '45', 'address1' => '宮崎市', 'address1_kana' => 'ミヤザキシ', 'address2' => '祗園', 'address3' => '1-77', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192801', 'station_id2' => '1192701', 'station_id3' => '-1', 'station_m' => '35', 'station_m2' => '35', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.4094662', 'lat' => '31.9268827', 'distance' => '0', 'view_lat' => '31.9268827', 'view_lng' => '131.4094662', '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' => '1', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9-22時', 'eigyo_doniti_text' => '9-22時', 'fee' => '0', 'fee_text' => '910円/h ', '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' => '宮崎市北部記念体育館 https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html miyahoku@info.com futsal 0985-28-0353 09 00 22 00 8800024 宮崎市 ミヤザキシ 祗園 1-77 9-22時 9-22時 910円/h &lt;p&gt;ご予約・お問い合わせ&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&gt;&lt;/p&gt; 2021/06/11 13:55:12', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2021/06/11 13:55:12', '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;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&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}('miyazaki')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' => '1384', 'name' => '宮崎市北部記念体育館', 'url' => 'https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html', 'url2' => '', 'mail' => 'miyahoku@info.com', 'password' => 'futsal', 'tel' => '0985-28-0353', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '22', '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' => '8800024', 'pref_id' => '45', 'address1' => '宮崎市', 'address1_kana' => 'ミヤザキシ', 'address2' => '祗園', 'address3' => '1-77', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192801', 'station_id2' => '1192701', 'station_id3' => '-1', 'station_m' => '35', 'station_m2' => '35', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.4094662', 'lat' => '31.9268827', 'distance' => '0', 'view_lat' => '31.9268827', 'view_lng' => '131.4094662', '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' => '1', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9-22時', 'eigyo_doniti_text' => '9-22時', 'fee' => '0', 'fee_text' => '910円/h ', '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' => '宮崎市北部記念体育館 https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html miyahoku@info.com futsal 0985-28-0353 09 00 22 00 8800024 宮崎市 ミヤザキシ 祗園 1-77 9-22時 9-22時 910円/h &lt;p&gt;ご予約・お問い合わせ&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&gt;&lt;/p&gt; 2021/06/11 13:55:12', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2021/06/11 13:55:12', '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;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&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}('miyazaki')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' => '1384', 'name' => '宮崎市北部記念体育館', 'url' => 'https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html', 'url2' => '', 'mail' => 'miyahoku@info.com', 'password' => 'futsal', 'tel' => '0985-28-0353', 'staff' => '', 'text' => '', 'stt_h' => '09', 'stt_m' => '00', 'end_h' => '22', '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' => '8800024', 'pref_id' => '45', 'address1' => '宮崎市', 'address1_kana' => 'ミヤザキシ', 'address2' => '祗園', 'address3' => '1-77', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192801', 'station_id2' => '1192701', 'station_id3' => '-1', 'station_m' => '35', 'station_m2' => '35', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.4094662', 'lat' => '31.9268827', 'distance' => '0', 'view_lat' => '31.9268827', 'view_lng' => '131.4094662', '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' => '1', 'court_cnt_text' => '', 'personal_use' => '2', 'personal_use_text' => '', 'eigyo_text' => '', 'eigyo_heijitu_text' => '9-22時', 'eigyo_doniti_text' => '9-22時', 'fee' => '0', 'fee_text' => '910円/h ', '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' => '宮崎市北部記念体育館 https://www.city.miyazaki.miyazaki.jp/health/sports/8698.html miyahoku@info.com futsal 0985-28-0353 09 00 22 00 8800024 宮崎市 ミヤザキシ 祗園 1-77 9-22時 9-22時 910円/h &lt;p&gt;ご予約・お問い合わせ&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&gt;&lt;/p&gt; 2021/06/11 13:55:12', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2021/06/11 13:55:12', '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;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.city.miyazaki.miyazaki.jp/health/sports/791.html&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;宮崎市公共施設予約案内システム&lt;/a&gt;&lt;/p&gt;&lt;p&gt;お問い合わせ TEL.0985-28-0353&lt;/p&gt;&lt;p&gt;※予約システム以外にも下記の使用申込書をご記入の上、管理事務所へお持ちください。&lt;br /&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.xls&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(Excel)&lt;/a&gt; &lt;a target=&quot;_blank&quot; href=&quot;http://www.mbs1962.com/shitei/wp-content/uploads/n-request2019.pdf&quot; rel=&quot;noopener&quot; target=&quot;_blank&quot;&gt;使用申込書(PDF)&lt;/a&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}('miyazaki')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