Template:Tour personnel: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) (Undo revision 72351 by MusikAnimal (talk)) |
||
| Line 1: | Line 1: | ||
< | {{div col|colwidth=20em}} | ||
{{#invoke: | {{#cargo_query: | ||
tables=shows | |||
|fields=lineup=person, COUNT(_ID)=count, {{#invoke:String|join|, |{{#if:{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}|shows.artist=artist, CONCAT('', "{{{artist}}}")=catalog_artist}}|{{#if:{{{tour|}}}|shows.tour=tour}}|{{#if:{{{year|}}}|YEAR(shows.date)=year}}|{{#if:{{{festival|}}}|shows.festival=festival}}}} | |||
|where={{#invoke:String|join| AND |{{#if:{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}|(shows.artist = "{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}" OR shows.featuring_artist = "{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}")}}|{{#if:{{{tour|}}}|shows.tour="{{{tour}}}"}}|{{#if:{{{artist|}}}|(shows.artist="{{{artist}}}" OR shows.featuring_artist="{{{artist}}}")}}|{{#if:{{{year|}}}|YEAR(shows.date)={{{year}}}}}|{{#if:{{{festival|}}}|shows.festival="{{{festival}}}"}}}} | |||
|group by=lineup | |||
|order by=Count DESC, person ASC | |||
|limit=250 | |||
|offset=0 | |||
|format=template | |||
|template=Tour personnel/Row | |||
|named args=yes | |||
}} | |||
{{div col end}}<noinclude>{{documentation}}</noinclude> | {{div col end}}<noinclude>{{documentation}}</noinclude> | ||
Revision as of 19:05, 9 February 2022
Template:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/Row
Lists personnel for shows matching the given criteria
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Artist | artist | no description | String | suggested |
| Tour | tour | no description | String | suggested |
| Year | year | no description | Number | suggested |
| Festival | festival | no description | String | suggested |
| The above documentation is transcluded from Template:Tour personnel/doc. (edit | history) Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages. Please add categories to the /doc subpage. Subpages of this template. |