3,726
edits
MusikAnimal (talk | contribs) m (MusikAnimal moved page Template:Tour history by artist to Template:Live performances by artist without leaving a redirect) |
MusikAnimal (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=shows | tables=shows | ||
|fields=CONCAT('[[', CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END, ' tour history|', CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END, ']]')=Artist, COUNT(_ID)=No. shows | |fields=CONCAT('[[', CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END, ' tour history|', CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END, ']]')=Artist, MIN(shows.date)=First date, MAX(date)=Last date, COUNT(_ID)=No. shows | ||
|group by=(CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END) | |group by=(CASE WHEN featuring_artist IS NULL THEN artist ELSE featuring_artist END) | ||
|order by=`No. shows` DESC | |order by=`No. shows` DESC |