北郷体育館(さくらアリーナ)

最寄駅
JR日南線/北郷から20分   同じ路線
住所
宮崎県日南市北郷町郷之原110   近くの施設 経路
電話番号
運営
公営
営業時間(平日)
8時半∼22時
営業時間(土日祝)
8時半∼22時

料金(ビジター)
3,510∼6,600円/ 3.5~5h (全面)

予約方法

予約に関しての詳細は下記ページより

北郷体育館 (さくらアリーナ)の予約方法

個人参加
無し
コート数
2
シャワー
有り
備考
日南市内(2)

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' => '1381', 'name' => '北郷体育館(さくらアリーナ)', 'url' => 'https://www.nichinan-taiiku.jp/facility/kitagou.php', 'url2' => '', 'mail' => 'kitago@info.com', 'password' => 'futsal', 'tel' => '0987-55-2897', 'staff' => '', 'text' => '', 'stt_h' => '08', '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' => '8892402', 'pref_id' => '45', 'address1' => '日南市', 'address1_kana' => 'ニチナンシ', 'address2' => '北郷町郷之原', 'address3' => '110', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192814', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '20', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.3740104', 'lat' => '31.6908029', 'distance' => '0', 'view_lat' => '31.6908029', 'view_lng' => '131.3740104', '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' => '8時半∼22時', 'eigyo_doniti_text' => '8時半∼22時', 'fee' => '0', 'fee_text' => '3,510∼6,600円/ 3.5~5h (全面)', '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.nichinan-taiiku.jp/facility/kitagou.php kitago@info.com futsal 0987-55-2897 08 00 22 00 8892402 日南市 ニチナンシ 北郷町郷之原 110 8時半∼22時 8時半∼22時 3,510∼6,600円/ 3.5~5h (全面) &lt;p&gt;予約に関しての詳細は下記ページより&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&lt;/a&gt;&lt;/p&gt; 2022/08/22 19:57:02', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2022/08/22 19:57:02', '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://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&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' => '1381', 'name' => '北郷体育館(さくらアリーナ)', 'url' => 'https://www.nichinan-taiiku.jp/facility/kitagou.php', 'url2' => '', 'mail' => 'kitago@info.com', 'password' => 'futsal', 'tel' => '0987-55-2897', 'staff' => '', 'text' => '', 'stt_h' => '08', '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' => '8892402', 'pref_id' => '45', 'address1' => '日南市', 'address1_kana' => 'ニチナンシ', 'address2' => '北郷町郷之原', 'address3' => '110', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192814', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '20', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.3740104', 'lat' => '31.6908029', 'distance' => '0', 'view_lat' => '31.6908029', 'view_lng' => '131.3740104', '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' => '8時半∼22時', 'eigyo_doniti_text' => '8時半∼22時', 'fee' => '0', 'fee_text' => '3,510∼6,600円/ 3.5~5h (全面)', '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.nichinan-taiiku.jp/facility/kitagou.php kitago@info.com futsal 0987-55-2897 08 00 22 00 8892402 日南市 ニチナンシ 北郷町郷之原 110 8時半∼22時 8時半∼22時 3,510∼6,600円/ 3.5~5h (全面) &lt;p&gt;予約に関しての詳細は下記ページより&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&lt;/a&gt;&lt;/p&gt; 2022/08/22 19:57:02', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2022/08/22 19:57:02', '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://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&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' => '1381', 'name' => '北郷体育館(さくらアリーナ)', 'url' => 'https://www.nichinan-taiiku.jp/facility/kitagou.php', 'url2' => '', 'mail' => 'kitago@info.com', 'password' => 'futsal', 'tel' => '0987-55-2897', 'staff' => '', 'text' => '', 'stt_h' => '08', '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' => '8892402', 'pref_id' => '45', 'address1' => '日南市', 'address1_kana' => 'ニチナンシ', 'address2' => '北郷町郷之原', 'address3' => '110', 'address4' => null, 'is_tokyo_23ku' => '2', 'line_id' => '11928', 'station_id' => '1192814', 'station_id2' => '-1', 'station_id3' => '-1', 'station_m' => '20', 'station_m2' => '0', 'station_m3' => '0', 'station_memo' => null, 'trafic' => '', 'parking' => '', 'lng' => '131.3740104', 'lat' => '31.6908029', 'distance' => '0', 'view_lat' => '31.6908029', 'view_lng' => '131.3740104', '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' => '8時半∼22時', 'eigyo_doniti_text' => '8時半∼22時', 'fee' => '0', 'fee_text' => '3,510∼6,600円/ 3.5~5h (全面)', '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.nichinan-taiiku.jp/facility/kitagou.php kitago@info.com futsal 0987-55-2897 08 00 22 00 8892402 日南市 ニチナンシ 北郷町郷之原 110 8時半∼22時 8時半∼22時 3,510∼6,600円/ 3.5~5h (全面) &lt;p&gt;予約に関しての詳細は下記ページより&lt;/p&gt;&lt;p&gt;&lt;a target=&quot;_blank&quot; href=&quot;http://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&lt;/a&gt;&lt;/p&gt; 2022/08/22 19:57:02', 'ins_datetime' => null, 'ins_login_id' => '0', 'upd_datetime' => '2022/08/22 19:57:02', '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://nichinan-taiiku.jp/reserve/kitago/&quot; target=&quot;_blank&quot;&gt;北郷体育館 (さくらアリーナ)の予約方法&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