Cargo query
Showing below up to 50 results in range #1 to #50.
- 1991-02-05 (The Smashing Pumpkins) Blind Pig (Ann Arbor, MI); Ann Arbor, MI, US
- 1991-02-06 (The Smashing Pumpkins) Babylon A Go-Go; Cleveland, OH, US
- 1991-02-08 (The Smashing Pumpkins) Maxwell's; Hoboken, NJ, US
- 1991-02-09 (The Smashing Pumpkins) T.T. The Bear's Place; Cambridge, MA, US
- 1991-02-10 (The Smashing Pumpkins) FastLane Club; Asbury Park, NJ, US
- 1991-02-12 (The Smashing Pumpkins) CBGB; New York, NY, US
- 1991-02-13 (The Smashing Pumpkins) J. C. Dobbs; Philadelphia, PA, US
- 1991-02-14 (The Smashing Pumpkins) Max's on Broadway; Baltimore, MD, US
- 1991-02-15 (The Smashing Pumpkins) 9:30 Club; Washington, DC, US
- 1991-02-16 (The Smashing Pumpkins) Stache's; Columbus, OH, US
- 1991-02-17 (The Smashing Pumpkins) Saint Andrew's Hall; Detroit, MI, US
- 1991-02-19 (The Smashing Pumpkins) Unicorn; Milwaukee, WI, US
- 1991-06-15 (The Smashing Pumpkins) Ranch Bowl; Omaha, NE, US
- 1991-06-17 (The Smashing Pumpkins) Grand Emporium; Kansas City, MO, US
- 1991-06-19 (The Smashing Pumpkins) Unicorn; Milwaukee, WI, US
- 1991-06-20 (The Smashing Pumpkins) ; Madison, WI, US
- 1991-06-22 (The Smashing Pumpkins) Reckless Records; Chicago, IL, US
- 1991-06-22 (The Smashing Pumpkins) Metro; Chicago, IL, US – release show for Gish; live debut of "Rocket"
- 1991-06-23 (The Smashing Pumpkins) Rose Records; Chicago, IL, US
- 1991-06-29 (The Smashing Pumpkins) Patio; Indianapolis, IN, US
- 1991-07-01 (The Smashing Pumpkins) Beat; Port Chester, NY, US
- 1991-07-09 (The Smashing Pumpkins) Stache's; Columbus, OH, US
- 1991-07-10 (The Smashing Pumpkins) Chilly's; Cincinnati, OH, US
- 1991-07-11 (The Smashing Pumpkins) Frankie's Inner City Lounge; Toledo, OH, US
- 1991-07-12 (The Smashing Pumpkins) Babylon A Go-Go; Cleveland, OH, US
- 1991-07-13 (The Smashing Pumpkins) Lee's Palace; Toronto, ON, CA
- 1991-07-15 (The Smashing Pumpkins) CBGB; New York, NY, US
- 1991-07-16 (The Smashing Pumpkins) Iron Horse; Northampton, MA, US
- 1991-07-18 (The Smashing Pumpkins) Khyber Pass Pub; Philadelphia, PA, US
- 1991-07-19 (The Smashing Pumpkins) Club Babyhead; Providence, RI, US
- 1991-07-20 (The Smashing Pumpkins) T.T. The Bear's Place; Cambridge, MA, US [Lollipopsandbooze festival]
- 1991-07-21 (The Smashing Pumpkins) Moon; New Haven, CT, US
- 1991-07-23 (The Smashing Pumpkins) Les Foufounes Électriques; Montreal, QC, CA
- 1991-07-26 (The Smashing Pumpkins) ZOOTZ; Portland, ME, US
- 1991-07-31 (The Smashing Pumpkins) Danceteria; New York, NY, US
- 1991-08-01 (The Smashing Pumpkins) 9:30 Club; Washington, DC, US
- 1991-08-03 (The Smashing Pumpkins) Maxwell's; Hoboken, NJ, US
- 1991-08-04 (The Smashing Pumpkins) Max's on Broadway; Baltimore, MD, US
- 1991-08-05 (The Smashing Pumpkins) Twisters; Richmond, VA, US
- 1991-08-06 (The Smashing Pumpkins) Cat's Cradle; Carrboro, NC, US
- 1991-08-07 (The Smashing Pumpkins) The Masquerade (Atlanta); Atlanta, GA, US
- 1991-08-09 (The Smashing Pumpkins) Emo's; Houston, TX, US
- 1991-08-10 (The Smashing Pumpkins) Trees; Dallas, TX, US
- 1991-08-12 (The Smashing Pumpkins) Tower Records; Los Angeles, CA, US
- 1991-08-13 (The Smashing Pumpkins) Chuy's; Tempe, AZ, US
- 1991-08-14 (The Smashing Pumpkins) English Acid; West Hollywood, CA, US
- 1991-08-15 (The Smashing Pumpkins) The Casbah (music venue); San Diego, CA, US
- 1991-08-17 (The Smashing Pumpkins) I-Beam_(nightclub); San Francisco, CA, US
- 1991-08-17 (The Smashing Pumpkins) Rough Trade (shops); San Francisco, CA, US
- 1991-08-19 (The Smashing Pumpkins) Melody Ballroom; Portland, OR, US
{{#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=0 |order by=shows.date ASC ASC |tables=shows, live_show_photos, live_show_videos |template=Live show row |where=shows.lineup HOLDS "D'arcy Wretzky" AND (shows.artist="The Smashing Pumpkins" OR shows.featuring_artist="The Smashing Pumpkins") AND YEAR(shows.date)=1991 }}