Template:City: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(32 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
{{#template_params:City}} | {{#template_params:City}} | ||
{{#cargo_declare:_table=Cities|City=Page}} | {{#cargo_declare:_table=Cities|City=Page}} | ||
</noinclude> | </noinclude><includeonly>{{#cargo_store:_table=Cities}} | ||
<includeonly>{{#cargo_store:_table=Cities}} | {| class="wikitable" style="width: 30em; font-size: 90%; border: 1px solid #aaaaaa; background-color: #f0f4f7; color: black; margin-bottom: 0.5em; margin-left: 1em; padding: 0.2em; float: right; clear: right; text-align:left;" | ||
{| class="wikitable" | ! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">{{PAGENAME}}</span> | ||
! | |||
|- | |- | ||
| {{#cargo_query:tables=Venues|where=City= '{{PAGENAME}}'}} | | 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> | |||
|- | |||
{{#cargo_query: | |||
tables=Venues | |||
|fields=Venues._pageName=LocationName | |||
|where= Venues.City= '{{PAGENAME}}' | |||
|format=template | |||
|template=CityInfoboxVenues | |||
|named args=yes | |||
}} | |||
|} | |} | ||
Line 16: | Line 27: | ||
|- | |- | ||
! During !! Date !! Event !! Venue !! Organizer(s) | ! During !! Date !! Event !! Venue !! Organizer(s) | ||
{{#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.