Template:Infobox tour: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>[[Category:Live performances by tour]]{{#vardefine:start_date|{{#cargo_query: | <includeonly>{{#if:{{{year|}}}|[[Category:Live performances by year]]|[[Category:Live performances by tour]]}}{{#vardefine:start_date|{{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=MIN(date) | |fields=MIN(date) | ||
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}" | |where=shows.artist = "{{{artist}}}" {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} | ||
}}}}{{#vardefine:end_date|{{#cargo_query: | }}}}{{#vardefine:end_date|{{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=MAX(date) | |fields=MAX(date) | ||
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}" | |where=shows.artist = "{{{artist}}}" {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} | ||
}}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | }}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | ||
| bodyclass = vevent | | bodyclass = vevent | ||
| title = ''{{{name}}}'' {{#if:{{#pos:{{{name}}}|residency}}||{{#if:{{#pos:{{{name}}}|Sessions}}||tour}}}} | | title = {{#if:{{{year|}}}|{{{artist}}} {{{year}}} tour history|''{{{name}}}'' {{#if:{{#pos:{{{name}}}|residency}}||{{#if:{{#pos:{{{name}}}|Sessions}}||tour}}}}}} | ||
| titleclass = summary | | titleclass = summary | ||
| subheader = [[Tour history|Tour]] by [[{{{artist|}}}]] | | subheader = {{#if:{{{name|}}}|[[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 29: | Line 29: | ||
tables=shows | tables=shows | ||
|fields=COUNT(DISTINCT shows._ID) | |fields=COUNT(DISTINCT shows._ID) | ||
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}" | |where=shows.artist = "{{{artist}}}" {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | ||
}}</includeonly> | }}</includeonly> | ||
| label16 = No. of cities | | label16 = No. of cities | ||
| Line 35: | Line 35: | ||
tables=shows | tables=shows | ||
|fields=COUNT(DISTINCT location) | |fields=COUNT(DISTINCT location) | ||
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}" | |where=shows.artist = "{{{artist}}}" {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | ||
}}</includeonly> | }}</includeonly> | ||
| label17 = No. of countries | | label17 = No. of countries | ||
| Line 41: | Line 41: | ||
tables=shows | tables=shows | ||
|fields=COUNT(DISTINCT country) | |fields=COUNT(DISTINCT country) | ||
|where=shows.artist = "{{{artist}}}" AND shows.tour = "{{{name}}}" | |where=shows.artist = "{{{artist}}}" {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | ||
}}</includeonly> | }}</includeonly> | ||
| label19 = Supporting artists | | label19 = Supporting artists | ||
Revision as of 04:32, 29 September 2020
| Start date | {{#var:start_date}} |
|---|---|
| End date | {{#var:end_date}} |