A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1214

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1214

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1106

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1106

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1004

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1004

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1010

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1010

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1109

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1109

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1108

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1108

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1006

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1006

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1011

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1011

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1012

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1012

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1104

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1104

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1105

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1105

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1213

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1213

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1107

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1107

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1009

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1009

Filename: core/MY_Controller.php

Line Number: 88

北海道のカレンダー （2023年8月）| スポエンCYCLE

北海道のカレンダー（2023年8月）

／ 全5件

受付中のみ表示

  • 開催月
  • 開催日
  • イベント名
  • 開催地

2023年08月

15日(火)

情報掲載のみJTO北海道縦断横断 自転車旅2023

北海道

19日(土)

受付終了第1回 オロロンライン・サンセット・ミーティング（OSM）3

北海道

20日(日)

受付終了Seicomart 北海道そらちグルメフォンド 202380

北海道

27日(日)

受付終了第7回　かみふらの十勝岳ヒルクライム大会202333

北海道

受付終了ペダルフェスタ2023 in オホーツク with 弱虫ペダルサイクリングチーム5

北海道

全5件

検索条件を変更

Page Top
  ベンチマーク  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Search / Calendar )  0.4688
Total Execution Time  0.4693
  GET データ  
$_GET['m']   8
$_GET['y']   2023
  メモリ使用量  
1,670,760 bytes
  POST データ  
POST データはありません
  URI 文字列  
calendar/hokkaido
  クラス/メソッド  
search/calendar
  データベース:  entry   クエリ: 3  (隠す)
0.0051   SELECT *
FROM "news_etc"
WHERE (timestamp_open is null or timestamp_open<=now()) and (timestamp_close is null or timestamp_close>now())
AND "category_news" =  1
AND "flag_open" =  1
ORDER BY "date_create" desc, "cd_news" desc
LIMIT 1 
0.2122    SELECT COUNT(*) AS count
                    FROM tournaments t LEFT OUTER JOIN category_calendar c ON t.tid = c.tid
                  WHERE (t.status = 1 AND t.timestamp_expose < now())
                  
                    AND (LOWER(t.category) = 'c' OR LOWER(t.subcategory) like '%c%') AND (t.loc_area IN (1) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (1))) AND TO_CHAR(c.startdate,'YYYYMM') = '202308' 
0.2405   SELECT t.tid,
                        t.name,
                        t.pr,
                        t.opendate,
                        t.loc_area,
                        t.location,
                        t.entrystart,
                        t.entrylimit,
                        t.entrystarttime,
                        t.entrylimittime,
                        t.onlinesubscription,
                        t.hidden,
                        t.openterm,
                        to_char(opendate,'D') as yobi,
                        t.etc,
                        CASE WHEN (t.tid IN (100657,100662,100195,100030,100342,100109,100482,100136,99377,99395,111,65808,73327,74292,74450,74848,74223,75061,75189,75357,75416,75377,75407,75368,75538,75665,76097,76354,77406,77416,77803,79099,76302,78586) and (t.entrylimit is null OR t.entrylimit >= CURRENT_DATE)) THEN 'pr' ELSE '' END AS important,c.startdate,c.event_loc_area,
                        (ARRAY_TO_STRING(ARRAY(SELECT CASE WHEN is_s3 = 1 THEN 's3_files/pr_photos/' || to_char(tid, 'FM99999999999') || '/' || name ELSE 'photos/' || name END FROM photos WHERE tid = t.tid and flag = 1 order by torder ASC),',')) AS photos,
                        (SELECT count(*) FROM cafe_new_articles a WHERE a.tournament_id = t.tid) AS cafecount,
                        (ARRAY_TO_STRING(ARRAY(SELECT genre FROM cycle_genre3 WHERE tid = t.tid ),',')) AS genre,
                        (ARRAY_TO_STRING(ARRAY(SELECT point FROM cycle_point WHERE tid = t.tid ),',')) AS point,
                        t.reverse_flag
                    FROM tournaments t LEFT OUTER JOIN category_calendar c ON t.tid = c.tid
                  WHERE (t.status = 1 AND timestamp_expose < now())
                    
                    AND (LOWER(t.category) = 'c' OR LOWER(t.subcategory) like '%c%') AND (t.loc_area IN (1) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (1))) AND TO_CHAR(c.startdate,'YYYYMM') = '202308' ORDER BY c.startdate ASC, t.loc_area ASC LIMIT 500 
  HTTP ヘッダ  (表示)
  設定変数  (表示)