EventList: Difference between revisions

VisualWikitext

Revision as of 16:57, 17 April 2026

2026: RSS · iCal

1.May 30-Jun 06: Norwegian Dragonkin Gathering, NO (Buskerud)

2.Oct 23-Oct 25: HowlCon, (Online)

2027:

1.Mar 05-Mar 07: The Centaurus Festival, (Online)

TBD:

1.OtherCon, (Online)

2.Shining Hearth Gathering, (Online)

@@ Line 23: / Line 23: @@
 {{#cargo_query:
 tables=CommunityEvents
-|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
+|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')
 and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
@@ Line 31: / Line 31: @@
 |sort=CommunityEvents.NextDateStart ASC
 |template=EventsList2
+|intro={{#vardefine:ITER_INDEX|0}}
 }}
 {{#vardefine:ITER_INDEX|0}}
 {{#cargo_query:
 tables=CommunityEvents
-|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
+|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')
 and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31'
@@ Line 43: / Line 44: @@
 |template=EventsList2
 |sort=CommunityEvents.NextDateStart ASC
-|intro={{b|{{#time: Y | +1 year}}:}}
+|intro={{#vardefine:ITER_INDEX|0}}{{b|{{#time: Y | +1 year}}:}}
 }}
 {{#vardefine:ITER_INDEX|0}}
 {{#cargo_query:
 tables=CommunityEvents
-|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
+|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')
 and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1))
@@ Line 54: / Line 55: @@
 |format=template
 |template=EventsList3
-|sort=CommunityEvents.Status ASC
+|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC
-|intro={{b|TBD:}}
+|intro={{#vardefine:ITER_INDEX|0}}{{b|TBD:}}
 }}