EventList: Difference between revisions
(Switching to Cargo) |
m (Fixed spacing.) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 22: | Line 22: | ||
{{#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 33: | Line 33: | ||
{{#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 45: | ||
{{#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 51: | 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:}} |
||
}} |
}} |
||