Template:Infobox tour: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
VisualWikitext
(Created page with "{{Infobox | bodyclass = vevent | title = {{{name|{{BASEPAGENAME}}}}} | titleclass = summary | subheader = Tour by {{{artist|}}} | subhe...")
 
No edit summary
Line 1: Line 1:
{{Infobox
<includeonly>{{#vardefine:start_date|{{#cargo_query:
tables=shows
|fields=MIN(date)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}}}
{{#vardefine:end_date|{{#cargo_query:
tables=shows
|fields=MAX(date)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}}}</includeonly>{{Infobox
| bodyclass      = vevent
| bodyclass      = vevent
| title          = {{{name|{{BASEPAGENAME}}}}}
| title          = {{{name|{{BASEPAGENAME}}}}}
| titleclass    = summary
| titleclass    = summary
| subheader      = [[Tour history|Tour]] by {{{artist|}}}
| subheader      = [[Tour history|Tour]] by [[{{{artist|}}}]]
| subheaderstyle = font-weight: bold;
| subheaderstyle = font-weight: bold;
| image          = {{#invoke:InfoboxImage|InfoboxImage|image={{{image|{{{poster|}}}}}}|size={{{image_size|}}}|title={{#ifeq:{{{landscape|}}}|yes||upright}}|border={{#if:{{{border|}}}|yes}}|alt={{{alt|}}}}}
| image          = {{#invoke:InfoboxImage|InfoboxImage|image={{{image|{{{poster|}}}}}}|size={{{image_size|}}}|title={{#ifeq:{{{landscape|}}}|yes||upright}}|border={{#if:{{{border|}}}|yes}}|alt={{{alt|}}}}}
Line 10: Line 19:
| data1          = {{{co-headliner|}}}
| data1          = {{{co-headliner|}}}
| label11        = Start date
| label11        = Start date
| data11        = <includeonly>{{#vardefine:start_date|{{#cargo_query:
| data11        = {{#var:start_date}}<!--<includeonly>[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>-->
tables=shows
|fields=MIN(date)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}}}[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>
| label12        = End date
| label12        = End date
| data12        = <includeonly>{{#vardefine:end_date|{{#cargo_query:
| data12        = {{#var:end_date}}<!--<includeonly>[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>-->
tables=shows
|fields=MAX(date)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}}}[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>
| label13        = Duration
| label13        = Duration
| data13        = {{{duration|}}}
| data13        = {{{duration|}}}
Line 30: Line 31:
|fields=COUNT(DISTINCT shows._ID)
|fields=COUNT(DISTINCT shows._ID)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
|join on=live_songs._pageName = shows._pageName
}}</includeonly>
}}</includeonly>
| label16        = Supporting artists
| label16       = No. of cities
| data16         = {{{supporting_artists|}}}
| data16        = <includeonly>{{#cargo_query:
tables=shows
|fields=COUNT(DISTINCT location)
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}"
}}</includeonly>
| label19       = Supporting artists
| data19         = {{{supporting_artists|}}}
}}
}}
__FORCETOC__

Revision as of 03:44, 9 September 2020

Infobox tour
Tour by [[]]
Start date{{#var:start_date}}
End date{{#var:end_date}}
Retrieved from "https://spcodex.wiki/index.php?title=Template:Infobox_tour&oldid=2714"