Cargo query
Showing below up to 16 results in range #1 to #16.
- 2019-08-08 (The Smashing Pumpkins) BB&T Pavilion; Camden, NJ, US
- 2019-08-09 (The Smashing Pumpkins) Jones Beach Theater; Wantagh, NY, US
- 2019-08-10 (The Smashing Pumpkins) Darien Lake Performing Arts Center; Darien, NY, US
- 2019-08-13 (The Smashing Pumpkins) Budweiser Stage; Toronto, ON, CA
- 2019-08-14 (The Smashing Pumpkins) DTE Energy Music Theatre; Clarkston, MI, US
- 2019-08-15 (The Smashing Pumpkins) Hollywood Casino Amphitheatre; Tinley Park, IL, US
- 2019-08-17 (The Smashing Pumpkins) Merriweather Post Pavilion; Columbia, MD, US
- 2019-08-19 (The Smashing Pumpkins) Blossom Music Center; Cuyahoga Falls, OH, US
- 2019-08-20 (The Smashing Pumpkins) PNC Music Pavilion; Charlotte, NC, US
- 2019-08-21 (The Smashing Pumpkins) Ameris Bank Amphitheatre; Alpharetta, GA, US
- 2019-08-23 (The Smashing Pumpkins) Walmart Arkansas Music Pavilion; Rogers, AR, US
- 2019-08-24 (The Smashing Pumpkins) Dos Equis Pavilion; Dallas, TX, US
- 2019-08-25 (The Smashing Pumpkins) Cynthia Woods Mitchell Pavilion; The Woodlands, TX, US
- 2019-08-28 (The Smashing Pumpkins) North Island Credit Union Amphitheatre; Chula Vista, CA, US
- 2019-08-29 (The Smashing Pumpkins) FivePoint Amphitheatre; Irvine, CA, US
- 2019-08-31 (The Smashing Pumpkins) Shoreline Amphitheatre; Mountain View, CA, 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 "Jeff Schroeder" AND (shows.artist="The Smashing Pumpkins" OR shows.featuring_artist="The Smashing Pumpkins") AND shows.tour="Summer 2019" |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 }}