Template:Tour personnel: Difference between revisions

Revision as of 04:45, 22 December 2020

Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row Template:Tour personnel/Row

@@ Line 2: / Line 2: @@
 {{#cargo_query:
 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
 |order by=Count DESC