Template:SatelliteEventByDate: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 20: | Line 20: | ||
{{#cargo_query: | {{#cargo_query: | ||
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}}}" | |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=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 | ||
Revision as of 00:04, 10 February 2024
This is the "SatelliteEventByDate" template. It should be called in the following format:
{{SatelliteEventByDate
|MainEvent=
|dateanchor=
|Date=
|DisplayDate=
}}