Template:Infobox tour: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
tables=shows | tables=shows | ||
|fields=MIN(date) | |fields=MIN(date) | ||
|where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} | |where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} {{#if:{{{festival|}}}|AND shows.festival = "{{{festival}}}"}} | ||
}}}}{{#vardefine:end_date|{{#cargo_query: | }}}}{{#vardefine:end_date|{{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=MAX(date) | |fields=MAX(date) | ||
|where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} | |where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}} {{#if:{{{festival|}}}|AND shows.festival = "{{{festival}}}"}} | ||
}}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | }}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | ||
| bodyclass = vevent | | bodyclass = vevent | ||
| title = {{#if:{{{year|}}}|{{{artist}}} {{{year}}} tour history|''{{{name}}} {{#if:{{#pos:{{{name}}}|residency}}||{{#if:{{#pos:{{{name}}}|Sessions}}||tour}}}}''}} | | title = {{#if:{{{festival|}}}|{{{festival}}}|{{#if:{{{year|}}}|{{{artist}}} {{{year}}} tour history|''{{{name}}} {{#if:{{#pos:{{{name}}}|residency}}||{{#if:{{#pos:{{{name}}}|Sessions}}||tour}}}}''}}}} | ||
| titleclass = summary | | titleclass = summary | ||
| subheader = {{#if:{{{name|}}}|[[Tour history|Tour]] by [[{{{artist|}}}]]}} | | subheader = {{#if:{{{name|}}}|[[Tour history|Tour]] by [[{{{artist|}}}]]}} | ||
Line 29: | Line 29: | ||
tables=shows | tables=shows | ||
|fields=COUNT(DISTINCT shows._ID) | |fields=COUNT(DISTINCT shows._ID) | ||
|where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | |where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} {{#if:{{{festival|}}}|AND shows.festival = "{{{festival}}}"}} | ||
}}</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}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | |where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} {{#if:{{{festival|}}}|AND shows.festival = "{{{festival}}}"}} | ||
}}</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}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} | |where=(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}") {{#if:{{{name|}}}|AND shows.tour = "{{{name}}}"|AND YEAR(shows.date) = {{{year}}}}} {{#if:{{{festival|}}}|AND shows.festival = "{{{festival}}}"}} | ||
}}</includeonly> | }}</includeonly> | ||
| label19 = Supporting artists | | label19 = Supporting artists | ||
Line 125: | Line 125: | ||
"label": "Year of next tour", | "label": "Year of next tour", | ||
"description": "Year or year range of the next tour" | "description": "Year or year range of the next tour" | ||
}, | |||
"festival": { | |||
"label": "Festival", | |||
"description": "Supply field instead of \"name\" or \"year\" to show data on appearances at the given festival", | |||
"type": "string" | |||
} | } | ||
}, | }, | ||
Line 146: | Line 151: | ||
"next_tour", | "next_tour", | ||
"this_year", | "this_year", | ||
"next_year" | "next_year", | ||
"festival" | |||
] | ] | ||
} | } | ||
</templatedata></noinclude> | </templatedata></noinclude> |
Revision as of 19:09, 18 October 2020
Start date | {{#var:start_date}} |
---|---|
End date | {{#var:end_date}} |
No description.
Parameter | Description | Type | Status | |
---|---|---|---|---|
Artist | artist | The name of the artist | Page name | required |
Name of tour | name | no description | String | suggested |
Image | image | no description | File | suggested |
Image caption | caption | no description | Unknown | optional |
Year | year | Use this instead of the 'tour' parameter on pages that list shows for a whole year and not a specific tour
| Number | optional |
Image size | image_size | no description | Unknown | optional |
landscape | landscape | no description | Unknown | optional |
border | border | no description | Unknown | optional |
alt | alt | no description | Unknown | optional |
image_caption | image_caption | no description | Unknown | optional |
Co-headlers | co-headliner | Other artists that co-headlined the tour, such as Marilyn Manson for The End Times tour | String | optional |
duration | duration | no description | Unknown | optional |
number_of_legs | number_of_legs | no description | Unknown | optional |
supporting_artists | supporting_artists | no description | Unknown | optional |
Name of previous tour | prev_tour | Previous tour for the this band | String | suggested |
Year of previous tour | prev_year | Year or year range of the previous tour
| Unknown | suggested |
Name of next tour | next_tour | Next tour by this band | Unknown | suggested |
Year of this tour | this_year | no description | Unknown | suggested |
Year of next tour | next_year | Year or year range of the next tour | Unknown | optional |
Festival | festival | Supply field instead of "name" or "year" to show data on appearances at the given festival | String | optional |