Template:ParentSatelliteEvent: Difference between revisions

From Edd's Almanac
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
{{#cargo_query:
{{#cargo_query:
tables=SatelliteEvents
tables=SatelliteEvents
|fields=MainEvent,Year,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory1,']]')=EventCategory1,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory2,']]')=EventCategory2,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory3,']]')=EventCategory3,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory4,']]')=EventCategory4,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory5,']]')=EventCategory5,StartDate,StartTime,EndTime,Duration,EventName,EventCategoryEmojis,URL,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,RSVP,StartingTicketPrice,FBOptions,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15,Notes
|fields=MainEvent,Year,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory1,']]')=EventCategory1,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory2,']]')=EventCategory2,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory3,']]')=EventCategory3,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory4,']]')=EventCategory4,CONCAT('[[Category:{{{MainEvent}}} {{{Year}}} Satellite Events - ',EventCategory5,']]')=EventCategory5,StartDate,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartTime,EndTime,Duration,EventName,EventCategoryEmojis,URL,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,RSVP,StartingTicketPrice,FBOptions,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15,Notes
|where= SatelliteEvents.EventName= '{{PAGENAME}}'
|where= SatelliteEvents.EventName= '{{PAGENAME}}'
|format=template
|format=template
|template=ParentSatelliteEventRow
|template=ParentSatelliteEventRow
|named args=yes
|named args=yes
|order by=StartTimeUnixTimestamp,EndTimeUnixTimestamp ASC
}}
}}
|}
|}

Revision as of 18:08, 13 February 2024

Iterations

During Date Time Link Location Host(s)

No results