|
|
Line 1: |
Line 1: |
| {{div col|colwidth=20em}} | | <templatestyles src="Template:Tour personnel/styles.css" />{{div col|colwidth=20em|class=tour-personnel plainlinks}} |
| {{#cargo_query:
| | {{#invoke:Tour personnel|main|{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}|{{{tour|}}}|{{{year|}}}|{{{festival|}}}}} |
| tables=shows
| |
| |fields=lineup=person, COUNT(_ID)=count, {{#invoke:String|join|, |{{#if:{{{artist|<noinclude>The Smashing Pumpkins</noinclude>}}}|shows.artist=artist, CONCAT('', "{{{artist}}}")=catalog_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}}}"}}}}
| |
| |group by=lineup
| |
| |order by=Count DESC, person ASC
| |
| |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> |