7月の祭り一覧をFestivalCalendarからリンク付きで表示 |
7月の祭り一覧をFestivalCalendarから自動表示 |
||
| 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.start_month <= 7 AND FC.end_month >= 7 | |where=FC.year={{CURRENTYEAR}} AND FC.start_month <= 7 AND FC.end_month >= 7 | ||
|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 | ||