Template:City: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (19 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">{{PAGENAME}}</span> | ! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">{{PAGENAME}}</span> | ||
|- | |- | ||
| style="text-align: left;" | Wikipedia Page | |||
| | | style="text-align: center;" | [https://en.wikipedia.org/{{localurl:{{PAGENAME}}}} {{PAGENAME}}] | ||
|- | |- | ||
! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">Venues Used For Satellite Events</span> | ! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">Venues Used For Satellite Events</span> | ||
|- | |- | ||
{{#cargo_query: | |||
tables=Venues | |||
|fields=Venues._pageName=LocationName | |||
|where= Venues.City= '{{PAGENAME}}' | |||
|format=template | |format=template | ||
|template=CityInfoboxVenues | |template=CityInfoboxVenues | ||
| Line 26: | Line 29: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=SatelliteEvents | tables=SatelliteEvents | ||
|fields=MainEvent,StartDate,EventName,URL, | |fields=MainEvent,StartDate,EventName,URL,EventCategory1,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 | ||
|where= SatelliteEvents.City= '{{PAGENAME}}' | |where= SatelliteEvents.City= '{{PAGENAME}}' | ||
|format=template | |format=template | ||
Latest revision as of 21:49, 12 February 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.