Cargo query
Showing below up to 43 results in range #1 to #43.
- 1991-10-16 (The Smashing Pumpkins) Oscar Mayer Theater; Madison, WI, US
- 1991-10-17 (The Smashing Pumpkins) Duke Ellington Ballroom; DeKalb, IL, US
- 1991-10-19 (The Smashing Pumpkins) Stephens Auditorium; Ames, IA, US
- 1991-10-20 (The Smashing Pumpkins) Peony Park Ballroom; Omaha, NE, US
- 1991-10-22 (The Smashing Pumpkins) Eagles Ballroom; Milwaukee, WI, US
- 1991-10-23 (The Smashing Pumpkins) Campus of Michigan State University; East Lansing, MI, US
- 1991-10-25 (The Smashing Pumpkins) AJ Palumbo Center; Pittsburgh, PA, US
- 1991-10-26 (The Smashing Pumpkins) Public Auditorium; Cleveland, OH, US
- 1991-10-27 (The Smashing Pumpkins) Auditorium Center; Rochester, NY, US
- 1991-10-29 (The Smashing Pumpkins) Masonic Temple (Toronto); Toronto, ON, CA
- 1991-10-30 (The Smashing Pumpkins) Masonic Temple (Toronto); Toronto, ON, CA
- 1991-11-01 (The Smashing Pumpkins) Walter Brown Arena; Boston, MA, US
- 1991-11-02 (The Smashing Pumpkins) Burlington Memorial Auditorium; Burlington, VT, US
- 1991-11-03 (The Smashing Pumpkins) MassMutual Center; Springfield, MA, US
- 1991-11-04 (The Smashing Pumpkins) Curry Hicks Cage; Amherst, MA, US
- 1991-11-05 (The Smashing Pumpkins) RPI Field House; Troy, NY, US
- 1991-11-07 (The Smashing Pumpkins) Landmark Theatre (Syracuse, New York); Syracuse, NY, US
- 1991-11-08 (The Smashing Pumpkins) Tower Theater; Upper Darby Township, PA, US
- 1991-11-09 (The Smashing Pumpkins) Bender Arena; Washington, DC, US
- 1991-11-11 (The Smashing Pumpkins) Roseland Ballroom; New York, NY, US
- 1991-11-12 (The Smashing Pumpkins) Roseland Ballroom; New York, NY, US
- 1991-11-13 (The Smashing Pumpkins) Rocky Point Amusement Park; Warwick, RI, US
- 1991-11-15 (The Smashing Pumpkins) Roseland Ballroom; New York, NY, US
- 1991-11-16 (The Smashing Pumpkins) Roseland Ballroom; New York, NY, US
- 1991-11-17 (The Smashing Pumpkins) Rec Hall; State College, PA, US
- 1991-11-19 (The Smashing Pumpkins) Veterans Memorial Auditorium; Columbus, OH, US
- 1991-11-20 (The Smashing Pumpkins) State Theater; Kalamazoo, MI, US
- 1991-11-22 (The Smashing Pumpkins) The Fillmore Detroit; Detroit, MI, US
- 1991-11-23 (The Smashing Pumpkins) The Fillmore Detroit; Detroit, MI, US
- 1991-11-24 (The Smashing Pumpkins) Indiana Convention Center; Indianapolis, IN, US
- 1991-11-26 (The Smashing Pumpkins) Braden Auditorium; Normal, IL, US
- 1991-11-27 (The Smashing Pumpkins) Cincinnati Gardens; Cincinnati, OH, US
- 1991-11-29 (The Smashing Pumpkins) Aragon Ballroom; Chicago, IL, US
- 1991-11-30 (The Smashing Pumpkins) Roy Wilkins Auditorium; Saint Paul, MN, US
- 1991-12-02 (The Smashing Pumpkins) American Theater; St. Louis, MO, US
- 1991-12-03 (The Smashing Pumpkins) American Theater; St. Louis, MO, US
- 1991-12-04 (The Smashing Pumpkins) Memorial Hall; Kansas City, KS, US
- 1991-12-06 (The Smashing Pumpkins) Municipal Auditorium (New Orleans); New Orleans, LA, US
- 1991-12-07 (The Smashing Pumpkins) Unicorn Ballroom; Houston, TX, US
- 1991-12-08 (The Smashing Pumpkins) City Coliseum; Austin, TX, US
- 1991-12-11 (The Smashing Pumpkins) Bronco Bowl; Dallas, TX, US
- 1991-12-12 (The Smashing Pumpkins) Hollywood Theater; Norman, OK, US
- 1991-12-14 (The Smashing Pumpkins) Denver Coliseum; Denver, CO, US
{{#cargo_query: tables=shows, live_show_photos, live_show_videos |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 |where=shows.lineup HOLDS "D'arcy Wretzky" AND (shows.artist="The Smashing Pumpkins" OR shows.featuring_artist="The Smashing Pumpkins") AND shows.tour="Blood Sugar Sex Magik" |join on=shows._pageName=live_show_photos._pageName, shows._pageName=live_show_videos._pageName |group by=shows._pageName |order by=shows.date ASC ASC |limit=1000 |format=template |template=Live show row |named args=yes }}