EventList: Difference between revisions
(Resetting index.) |
m (Fixed spacing.) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 20: | Line 20: | ||
|icalendar description=A calendar of upcoming community events |
|icalendar description=A calendar of upcoming community events |
||
}} |
}} |
||
{{#vardefine:ITER_INDEX|0}} |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=CommunityEvents |
tables=CommunityEvents |
||
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, |
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N |
||
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
||
and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY) |
and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY) |
||
| Line 32: | Line 31: | ||
|template=EventsList2 |
|template=EventsList2 |
||
}} |
}} |
||
{{#vardefine:ITER_INDEX|0}} |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=CommunityEvents |
tables=CommunityEvents |
||
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, |
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N |
||
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
||
and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31' |
and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31' |
||
| Line 45: | Line 43: | ||
|intro={{b|{{#time: Y | +1 year}}:}} |
|intro={{b|{{#time: Y | +1 year}}:}} |
||
}} |
}} |
||
{{#vardefine:ITER_INDEX|0}} |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables=CommunityEvents |
tables=CommunityEvents |
||
|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, |
|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.Status ASC,CommunityEvents._PageName ASC)=N |
||
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
||
and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1)) |
and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1)) |
||
| Line 54: | Line 51: | ||
|format=template |
|format=template |
||
|template=EventsList3 |
|template=EventsList3 |
||
|sort=CommunityEvents.Status ASC |
|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC |
||
|intro={{b|TBD:}} |
|intro={{b|TBD:}} |
||
}} |
}} |
||