Template: Event
(nav header) |
No edit summary |
||
Line 31: | Line 31: | ||
| tables = events | | tables = events | ||
| fields = CONCAT('[[',_pageName,']], ',DATE_FORMAT(start_date, '%e %M %Y'),'')=prev_event | | fields = CONCAT('[[',_pageName,']], ',DATE_FORMAT(start_date, '%e %M %Y'),'')=prev_event | ||
| where = start_date IS NOT NULL AND start_date < '{{{start_date}}}' | | where = region = '{{{region}}}' AND start_date IS NOT NULL AND start_date < '{{{start_date}}}' | ||
| order by = start_date DESC | | order by = start_date DESC | ||
| limit = 1 | | limit = 1 | ||
Line 40: | Line 40: | ||
| tables = events | | tables = events | ||
| fields = CONCAT('[[',_pageName,']], ',DATE_FORMAT(start_date, '%e %M %Y'),'')=next_event | | fields = CONCAT('[[',_pageName,']], ',DATE_FORMAT(start_date, '%e %M %Y'),'')=next_event | ||
| where = start_date IS NOT NULL AND start_date > '{{{start_date|}}}' | | where = region = '{{{region}}}' AND start_date IS NOT NULL AND start_date > '{{{start_date|}}}' | ||
| order by = start_date ASC | | order by = start_date ASC | ||
| limit = 1 | | limit = 1 |
Revision as of 05:11, 15 October 2019
This template defines the table "events". View table.
Events in {{{region}}}
Event