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|<noinclude>The Smashing Pumpkins</noinclude>}}}|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|}}}|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}}}"}}}}
|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

Revision as of 05:53, 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

Template documentation[view] [edit] [history] [purge]

Lists personnel for shows matching the given criteria

[Edit template data]

Template parameters

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
Artistartist

no description

Stringsuggested
Tourtour

no description

Stringsuggested
Yearyear

no description

Numbersuggested
Festivalfestival

no description

Stringsuggested