Cargo query
Showing below up to 8 results in range #51 to #58.
- 2024-09-18 (The Smashing Pumpkins) Chase Field; Phoenix, AZ, US
- 2024-09-20 (The Smashing Pumpkins) Oracle Park; San Francisco, CA, US
- 2024-09-21 (The Smashing Pumpkins) Grand Sierra Resort; Reno, NV, US
- 2024-09-23 (The Smashing Pumpkins) T-Mobile Park; Seattle, WA, US
- 2024-09-24 (The Smashing Pumpkins) BECU Live Outdoor Venue; Airway Heights, WA, US
- 2024-09-25 (The Smashing Pumpkins) Providence Park; Portland, OR, US
- 2024-09-27 (The Smashing Pumpkins) Fountainebleau Las Vegas; Las Vegas, NV, US
- 2024-09-28 (The Smashing Pumpkins) Petco Park; San Diego, CA, 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 |mobileaction=toggle_view_desktop |named args=yes |offset=50 |order by=shows.date ASC ASC |tables=shows, live_show_photos, live_show_videos |template=Live show row |where=shows.lineup HOLDS "Kiki Wong" AND (shows.artist="The Smashing Pumpkins" OR shows.featuring_artist="The Smashing Pumpkins") AND YEAR(shows.date)=2024 }}