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}}}" {{#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}} | ||
}}}}{{#vardefine:end_date|{{#cargo_query: | }}}}{{#vardefine:end_date|{{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=MAX(date) | |fields=MAX(date) | ||
|where=shows.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}} | ||
}}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | }}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox | ||
| bodyclass = vevent | | bodyclass = vevent | ||
| Line 17: | Line 17: | ||
| label1 = Co-headliners | | label1 = Co-headliners | ||
| data1 = {{{co-headliner|}}} | | data1 = {{{co-headliner|}}} | ||
| label11 = Start date | | label11 = {{#if:{{{year|}}}|First|Start}} date | ||
| data11 = {{#var:start_date}}<!--<includeonly>[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>--> | | data11 = {{#var:start_date}}<!--<includeonly>[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>--> | ||
| label12 = End date | | label12 = {{#if:{{{year|}}}|Last|End}} date | ||
| data12 = {{#var:end_date}}<!--<includeonly>[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>--> | | data12 = {{#var:end_date}}<!--<includeonly>[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>--> | ||
| label13 = Duration | | label13 = Duration | ||
| Line 29: | Line 29: | ||
tables=shows | tables=shows | ||
|fields=COUNT(DISTINCT shows._ID) | |fields=COUNT(DISTINCT shows._ID) | ||
|where=shows.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}}}}} | ||
}}</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}}}" {{#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}}}}} | ||
}}</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}}}" {{#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}}}}} | ||
}}</includeonly> | }}</includeonly> | ||
| label19 = Supporting artists | | label19 = Supporting artists | ||
Revision as of 18:35, 29 September 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 |