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={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} | |where=shows.date__precision=1 AND {{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}}}}}} | ||
}}}}{{#vardefine:end_date|{{#cargo_query: | }}}}{{#vardefine:end_date|{{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=MAX(date) | |fields=MAX(date) | ||
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}} | |where=shows.date__precision=1 AND {{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|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 = {{#if:{{{festival|}}}|{{{festival}}}|{{#if:{{{year|}}}|{{#if:{{{artist|}}}|{{{artist}}}}} {{{year}}} tour history|''{{{tour}}} {{#if:{{#pos:{{{tour}}}|residency}}||{{#if:{{#pos:{{{tour}}}|Sessions}}||tour}}}}''}}}} | | title = {{#if:{{{festival|}}}|{{{festival}}}|{{#if:{{{year|}}}|{{#if:{{{artist|}}}|{{{artist}}}}} {{{year}}} tour history|{{#if:{{{tour|}}}|''{{{tour}}} {{#if:{{#pos:{{{tour}}}|residency}}||{{#if:{{#pos:{{{tour}}}|Sessions}}||tour}}}}''|{{{artist}}} tour history}}}}}} | ||
| titleclass = summary | | titleclass = summary | ||
| subheader = {{#if:{{{tour|}}}|[[{{{artist}}} tour history|Tour]] by [[{{{artist|}}}]]}} | | subheader = {{#if:{{{tour|}}}|[[{{{artist}}} tour history|Tour]] by [[{{{artist|}}}]]}} |
Revision as of 04:17, 19 October 2020
First date | {{#var:start_date}} |
---|---|
Last date | {{#var:end_date}} |
No description.
Parameter | Description | Type | Status | |
---|---|---|---|---|
Artist | artist | The name of the artist | Page name | required |
Name of tour | tour | 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 |