Cargo query
Showing below up to 18 results in range #1 to #18.
- 2001-03-22 (The Nicholas Tremulis Orchestra featuring Billy Corgan) Metro; Chicago, IL, US – The Third Waltz benefit show
- 2001-05-10 (Royal Bliss featuring Billy Corgan) Liquid Joe's; Salt Lake City, UT, US
- 2001-06-12 (Billy Corgan) WGN-TV; Chicago, IL, US – "Bozo: 40 Years of Fun!" The final taping of The Bozo Show, featuring Billy Corgan and friends
- 2001-07-18 (New Order featuring Billy Corgan) Liverpool Olympia; Liverpool, UK
- 2001-07-28 (New Order featuring Billy Corgan) Naeba Ski Resort; Yuzawa, JP [Fuji Rock Festival]
- 2001-07-31 (New Order featuring Billy Corgan) Shoreline Amphitheatre; Mountain View, CA, US
- 2001-08-02 (New Order featuring Billy Corgan) Thunderbird Stadium; Vancouver, BC, CA [Area Festival]
- 2001-08-03 (New Order featuring Billy Corgan) The Gorge Amphitheatre; George, WA, US [Area Festival]
- 2001-08-05 (New Order featuring Billy Corgan) Glen Helen Amphitheater; San Bernadino, CA, US [Area Festival]
- 2001-11-14 (Zwan) Track 16 Gallery; Santa Monica, CA, US – Zwan's first show; secret show with unknown setlist
- 2001-11-16 (Zwan) Glass House; Pomona, CA, US – Zwan's first ticketed event
- 2001-11-18 (Zwan) Galaxy Theater; Santa Ana, CA, US
- 2001-11-20 (Zwan) Canes Bar and Grill; San Diego, CA, US
- 2001-11-21 (Zwan) Roxy Theatre; West Hollywood, CA, US
- 2001-12-13 (Zwan) The Intersection; Grand Rapids, MI, US
- 2001-12-13 (Zwan) The Intersection; Grand Rapids, MI, US
- 2001-12-14 (Zwan) The Emerson Theater; Indianapolis, IN, US
- 2001-12-14 (Zwan) The Emerson Theater; Indianapolis, IN, 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 "Billy Corgan" AND YEAR(shows.date)=2001 |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 }}