Template:SatelliteEventByDate: Difference between revisions

Revision as of 17:56, 8 February 2024

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

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

@@ Line 20: / Line 20: @@
 {{#cargo_query:
 tables=SatelliteEvents
-|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventCategory12}}}"
+|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter12}}}"
 |fields=MainEvent,SideEventType,City,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartDate,StartTime,EndTime,EventName,EventType,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

Template:SatelliteEventByDate: Difference between revisions

Revision as of 17:56, 8 February 2024

Navigation menu