Events: Difference between revisions
Dustin Loup (talk | contribs) No edit summary |
Dustin Loup (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
|fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region | |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region | ||
|where=DATEDIFF(End,NOW()) >= 0 | |where=DATEDIFF(End,NOW()) >= 0 | ||
|order by=Start ASC | |||
|format=dynamic table | |format=dynamic table | ||
}}</div> | }}</div> | ||
| Line 13: | Line 14: | ||
|fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region | |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region | ||
|where=DATEDIFF(End,NOW()) <= 0 | |where=DATEDIFF(End,NOW()) <= 0 | ||
||order by=Start ASC | |||
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
Revision as of 23:09, 31 January 2018
Upcoming Events
{{#cargo_query:|tables=Event |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region |where=DATEDIFF(End,NOW()) >= 0 |order by=Start ASC |format=dynamic table
}}Calendar of Events
Past Events
{{#cargo_query: |tables=Event |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y")=Start,DATE_FORMAT(End, "%M %e, %Y")=End,Country_or_Territory,Region |where=DATEDIFF(End,NOW()) <= 0 ||order by=Start ASC |format=dynamic table }}