Template:Tour personnel: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=lineup=person, COUNT(_ID)=count | |fields=lineup=person, COUNT(_ID)=count, {{#if:{{{artist|}}}|shows.artist=artist,}} {{#if:{{{tour|}}}|shows.tour=tour,}} {{#if:{{{year|}}}|shows.year=year,}} {{#if:{{{festival|}}}|shows.festival=festival}} | ||
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|artist = {{{artist|The Smashing Pumpkins}}}}}|{{#if:{{{tour|}}}|tour="{{{tour}}}"}}|{{#if:{{{artist|}}}|(artist="{{{artist}}}" OR featuring_artist="{{{artist}}}")}}|{{#if:{{{year|}}}|YEAR(date)={{{year}}}}}|{{#if:{{{festival|}}}|festival="{{{festival}}}"}}}} | |where={{#invoke:String|join| AND |{{#if:{{{artist|The Smashing Pumpkins}}}|shows.artist = "{{{artist|The Smashing Pumpkins}}}"}}|{{#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 | |group by=lineup | ||
|order by=Count DESC | |order by=Count DESC |
Revision as of 05:35, 21 December 2020
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/Row