12月の祭り一覧をFestivalCalendarから自動表示 |
Use LOCALYEAR for JST New Year boundary |
||
| 7行目: | 7行目: | ||
|join on=FC.festival_id=F.festival_id | |join on=FC.festival_id=F.festival_id | ||
|fields=F._pageName,F.name,FC.start_date,FC.end_date,FC.status | |fields=F._pageName,F.name,FC.start_date,FC.end_date,FC.status | ||
|where=FC.year={{ | |where=FC.year={{LOCALYEAR}} AND FC.start_month <= 12 AND FC.end_month >= 12 | ||
|group by=F._pageName,F.name,FC.start_date,FC.end_date,FC.status | |group by=F._pageName,F.name,FC.start_date,FC.end_date,FC.status | ||
|order by=FC.start_date ASC,F.name ASC | |order by=FC.start_date ASC,F.name ASC | ||