Template:Live performances by artist: Difference between revisions
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 | ||
Latest revision as of 04:32, 1 October 2020
| Artist | First date | Last date | No. shows |
|---|---|---|---|
| The Smashing Pumpkins | 1988-01-01 | 2024-09-28 | 1,638 |
| Billy Corgan | 1990-05-11 | 2023-12-31 | 269 |
| Zwan | 2001-11-14 | 2003-06-13 | 108 |
| Jimmy Chamberlin Complex | 2005-01-06 | 2005-09-18 | 57 |
| Jimmy Chamberlin | 1992-03-27 | 2023-12-07 | 48 |
| James Iha | 1994-09-04 | 2015-04-07 | 44 |
| Tinted Windows | 2009-03-18 | 2021-05-05 | 24 |
| Spirits in the Sky | 2009-07-24 | 2009-08-31 | 8 |
| Starchildren | 1990-02-24 | 1994-06-18 | 4 |
| D'arcy Wretzky | 1996-11-07 | 1996-11-07 | 1 |