Template:Tour personnel: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
No edit summary
No edit summary
Line 2: Line 2:
{{#cargo_query:
{{#cargo_query:
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|<noinclude>The Smashing Pumpkins</noinclude>}}}|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|<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
|group by=lineup
|order by=Count DESC
|order by=Count DESC

Revision as of 04:45, 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/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/RowTemplate:Tour personnel/Row