Template:Tour personnel: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
No edit summary
No edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{div col|colwidth=20em}}
{{div col|colwidth=20em|class=no-red-links plainlinks}}
{{#cargo_query:
{{#invoke:Tour personnel|main|{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}|{{{tour|}}}|{{{year|}}}|{{{festival|}}}}}
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}}
|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
|limit=250
|offset=0
|format=template
|template=Tour personnel/Row
|named args=yes
}}
{{div col end}}<noinclude>{{documentation}}</noinclude>
{{div col end}}<noinclude>{{documentation}}</noinclude>

Latest revision as of 00:34, 10 February 2022

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