Cargo query
Showing below up to 6 results in range #101 to #106.
- 1994-08-30 (The Smashing Pumpkins) Cloverdale Fairgrounds; Surrey, BC, CA [Lollapalooza 1994]
- 1994-08-31 (The Smashing Pumpkins) Gorge Amphitheater; George, WA, US [Lollapalooza 1994]
- 1994-09-01 (The Smashing Pumpkins) Gorge Amphitheater; George, WA, US [Lollapalooza 1994]
- 1994-09-04 (The Smashing Pumpkins) Velodrome Field; Carson, CA, US [Lollapalooza 1994]
- 1994-09-05 (The Smashing Pumpkins) Velodrome Field; Carson, CA, US [Lollapalooza 1994]
- 1994-09-08 (The Smashing Pumpkins) Radio City Music Hall; New York, NY, US – First appearance at the MTV Video Music Awards
{{#cargo_query: fields=shows._pageName=page_name, shows.date=date, shows.artist=artist, shows.featuring_artist=featuring_artist, shows.venue=venue, shows.location=location, shows.festival=festival, shows.notes=notes, IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, '', '1')=photos, live_show_videos._ID=video |format=template |group by=shows._pageName |join on=shows._pageName=live_show_photos._pageName, shows._pageName=live_show_videos._pageName |named args=yes |offset=100 |order by=shows.date ASC ASC |tables=shows, live_show_photos, live_show_videos |template=Live show row |where=shows.lineup HOLDS "Jimmy Chamberlin" AND YEAR(shows.date)=1994 }}