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:}} |
||
}} |
}} |
||
Latest revision as of 16:59, 17 April 2026
1.May 30-Jun 06: Norwegian Dragonkin Gathering, NO (Buskerud)
2.Jun 18-Jun 21: Dragonkin Meetup, NL (Overijssel)
3.Aug 08-Aug 16: Draconic Summit Iceland Eclipse Meetup, IS (Höfuðborgarsvæðið)
4.Aug 14-Aug 16: OtherCon, (Online)
5.Oct 23-Oct 25: HowlCon, (Online)
6.Dec 31-Jan 03: Happy 2027!, UK (England)
2027:
1.Dec 31-Jan 03: Happy 2027!, UK (England)
2.Mar 05-Mar 07: The Centaurus Festival, (Online)
TBD:
1.Shining Hearth Gathering, (Online)