3,725
edits
Template:Live performances by year: Difference between revisions
Template:Live performances by year (edit)
Revision as of 18:24, 29 September 2020
, 29 September 2020no edit summary
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
tables=shows | tables=shows | ||
|fields=CONCAT('[[{{#if:{{{artist|}}}|{{{artist}}}|}} ', YEAR(date), ' tour history|', YEAR(date), ']]')=Year, MIN(date)=First date, MAX(date)=Last date, COUNT(shows._ID)=No. shows | |fields=CONCAT('[[{{#if:{{{artist|}}}|{{{artist}}}|}} ', YEAR(date), ' tour history|', YEAR(date), ']]')=Year, MIN(date)=First date, MAX(date)=Last date, COUNT(shows._ID)=No. shows | ||
|where={{#if:{{{artist|}}}|artist="{{{artist}}}"}} | |where={{#if:{{{artist|}}}|artist="{{{artist}}}" OR featuring_artist="{{{artist}}}"}} | ||
|group by=year | |group by=year | ||
|order by=year ASC | |order by=year ASC | ||