Cargo query

Showing below up to 25 results in range #1 to #25.

_pageName	Venue	venue type	capacity	location	coords
Billy Corgan 2005-06-29	Fenway Park	Locker Room	37,755	Boston, MA, US	42.34625,-71.09775
Billy Corgan 2005-06-30	Avalon	Club	2,000	Boston, MA, US	42.347243,-71.095704
James Iha 2012-10-04	Church		225	Boston, MA, US	42.342365,-71.099334
Jimmy Chamberlin Complex 2005-01-18	Paradise Rock Club	Club	933	Boston, MA, US	42.351667,-71.119722
Jimmy Chamberlin Complex 2005-05-02	Paradise Rock Club	Club	933	Boston, MA, US	42.351667,-71.119722
The Smashing Pumpkins 1991-09-23	Axis	Club	1,100	Boston, MA, US	42.347243,-71.095541
The Smashing Pumpkins 1991-11-01	Walter Brown Arena	Arena	3,806	Boston, MA, US	42.354029,-71.120312
The Smashing Pumpkins 1996-11-05	TD Garden	Arena	20,000	Boston, MA, US	42.366303,-71.062228
The Smashing Pumpkins 1998-07-31	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2007-10-13	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2007-10-15	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2007-10-16	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2008-11-14	Wang Theatre	Theater	3,600	Boston, MA, US	42.35027778,-71.06472222
The Smashing Pumpkins 2008-11-15	Wang Theatre	Theater	3,600	Boston, MA, US	42.35027778,-71.06472222
The Smashing Pumpkins 2011-10-21	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2012-10-27	Agganis Arena	Arena	7,200	Boston, MA, US	42.35223056,-71.11779167
The Smashing Pumpkins 2015-07-28	Blue Hills Bank Pavilion	Amphitheater	5,000	Boston, MA, US	42.34861111,-71.03611111
The Smashing Pumpkins 2016-04-09	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
The Smashing Pumpkins 2018-07-31	TD Garden	Arena	20,000	Boston, MA, US	42.366303,-71.062228
The Smashing Pumpkins 2022-10-16	TD Garden	Arena	20,000	Boston, MA, US	42.366303,-71.062228
The Smashing Pumpkins 2024-08-07	Fenway Park	Stadium	37,755	Boston, MA, US	42.34646,-71.0971
Tinted Windows 2009-08-03	Paradise Rock Club	Club	933	Boston, MA, US	42.351667,-71.119722
Tinted Windows 2010-01-09	House of Blues	Club	2,200	Boston, MA, US	42.34808182885755,-71.09569869998282
Zwan 2002-12-11	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833
Zwan 2003-03-27	Orpheum Theatre (Boston)	Theater	2,700	Boston, MA, US	42.356222,-71.060833

Modify query

View wikitext

{{#cargo_query:
tables=shows
|fields=_pageName, CONCAT('[[', venue, ']]')=Venue, venue_type, capacity, location, coords
|where=location = 'Boston, MA, US'
}}

Table(s):
Field(s):
Where:	location = 'Boston, MA, US'
Join on:
Group by:
Having:
Order by:
Limit:
Offset:
Format: