Template:Tour personnel: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
tables=shows | tables=shows | ||
|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}} | |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|The Smashing Pumpkins}}}|shows.artist = "{{{artist|The Smashing Pumpkins}}}" OR shows.featuring_artist = "{{{artist}}}"}}|{{#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}}}"}}}} | |where={{#invoke:String|join| AND |{{#if:{{{artist|The Smashing Pumpkins}}}|(shows.artist = "{{{artist|The Smashing Pumpkins}}}" OR shows.featuring_artist = "{{{artist}}}"}})|{{#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 04:37, 22 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