Template:SatelliteEventByDate: Difference between revisions

From Edd's Almanac
Jump to navigation Jump to search
No edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 21: Line 21:
tables=SatelliteEvents
tables=SatelliteEvents
|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter12}}}"
|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory2="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory3="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory4="{{{EventFilter12}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory5="{{{EventFilter12}}}"
|fields=MainEvent,EventCategory1,City,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartDate,StartTime,EndTime,EventName,EventCategoryEmojis,URL,StartingTicketPrice,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,ZipCode,MapLink,RSVP,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,AddEventID
|fields=_pageName,MainEvent,EventCategory1,City,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartDate,StartTime,EndTime,EventName,EventCategoryEmojis,URL,StartingTicketPrice,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,ZipCode,MapLink,RSVP,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,AddEventID
|format=template
|format=template
|template=SatelliteEventRowDisplay
|template=SatelliteEventRowDisplay
Line 27: Line 27:
|order by=StartTimeUnixTimestamp,EndTimeUnixTimestamp ASC
|order by=StartTimeUnixTimestamp,EndTimeUnixTimestamp ASC
}}
}}
 
|colspan="8" style="text-align: left";| [[#top|Back to top ↑]]
|-


</includeonly>
</includeonly>

Latest revision as of 15:10, 11 February 2024

This is the "SatelliteEventByDate" template. It should be called in the following format:

{{SatelliteEventByDate
|MainEvent=
|dateanchor=
|Date=
|DisplayDate=
}}