Template:Live performances by year: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
VisualWikitext
No edit summary
No edit summary
Line 1: Line 1:
{{#cargo_query:
{{#cargo_query:
tables=shows
tables=shows
|fields=YEAR(date)=Year, COUNT(shows._ID)=No. shows
|fields=CONCAT('[[{{#if:{{{artist|}}}|{{{artist}}}|}} ', YEAR(date), ' tour history|', YEAR(date), ']]')=Year, COUNT(shows._ID)=No. shows
|where={{#if:{{{artist|}}}|artist="{{{artist}}}"}}
|where={{#if:{{{artist|}}}|artist="{{{artist}}}"}}
|group by=year
|group by=year

Revision as of 05:33, 29 September 2020

Year No. shows
1988 19
1989 28
1990 45
1991 126
1992 73
1993 105
1994 109
1995 17
1996 155
1997 46
1998 87
1999 16
2000 134
2001 22
2002 30
2003 78
2004 20
2005 115
2006 10
2007 94
2008 84
2009 33
2010 75
2011 42
2012 61
2013 59
2014 38
2015 57
2016 36
2017 55
2018 60
2019 56
2020 7
2021 27
2022 68
2023 58
2024 58
Retrieved from "https://spcodex.wiki/index.php?title=Template:Live_performances_by_year&oldid=2691"