Template:SatelliteEventFilter: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 14: | Line 14: | ||
tables=SatelliteEvents | tables=SatelliteEvents | ||
|where=MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory1}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory2}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory3}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory4}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory5}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory6}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory7}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory8}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory9}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory10}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory11}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory12}}}" | |where=MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory1}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory2}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory3}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory4}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory5}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory6}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory7}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory8}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory9}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory10}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory11}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-15" AND SideEventType="{{{EventCategory12}}}" | ||
|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=SatelliteEventRowDisplay | |||
|named args=yes | |||
|order by=StartTimeUnixTimestamp,EndTimeUnixTimestamp ASC | |||
}} | |||
!colspan="8"| <div id="feb15">Thursday, February 15, 2024</div> | |||
|- | |||
! style="background-color:#cccccc;" | Date !! style="background-color:#cccccc;" | Time !! style="background-color:#cccccc;" | Event !! style="background-color:#cccccc;" | Starting<br/>Ticket Price !! style="background-color:#cccccc;" | Location !! style="background-color:#cccccc;" | F&B !! style="background-color:#cccccc;" | Host(s) !! style="background-color:#cccccc;" | Add To Calendar | |||
|- | |||
{{#cargo_query: | |||
tables=SatelliteEvents | |||
|where=MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory1}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory2}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory3}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory4}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory5}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory6}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory7}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory8}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory9}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory10}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory11}}}" OR MainEvent="ETHDenver" AND StartDate="2024-02-28" AND SideEventType="{{{EventCategory12}}}" | |||
|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 | |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 | |format=template | ||
Line 21: | Line 34: | ||
}} | }} | ||
|} | |} | ||
</includeonly> | </includeonly> |
Revision as of 04:55, 8 February 2024
This is the "SatelliteEventFilter" template.
Edit the page to see the template text. This template defines the table "SatelliteEventFilter". This table has not been created yet.