Template:City: Difference between revisions

Revision as of 19:01, 28 January 2024

This is the "City" template.

It should be called in the following format:

{{City
|City=
}}

Edit the page to see the template text.

This template defines the table "Cities". View table.

@@ Line 11: / Line 11: @@
 ! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">Venues Used For Satellite Events</span>
 {{#cargo_query:
-tables=SatelliteEvents
+tables=Venues
-|fields=MainEvent,StartDate,EventName,URL,EventType,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,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
+|fields=Page,City
-|where= SatelliteEvents.City= '{{PAGENAME}}'
+|where= Venues.City= '{{PAGENAME}}'
 |format=template
 |template=CityInfoboxVenues