Template:Today in history: Difference between revisions

Revision as of 23:53, 16 December 2020

Page Template:Live show row/styles.css has no content.{{#vardefine:birthdays|}}==== Birthdays ==== {{#var:birthdays}}

1996: (The Smashing Pumpkins) Breslin Center; East Lansing, MI, US
2000: (The Smashing Pumpkins) Rotterdam Ahoy; Rotterdam, NL
2010: (The Smashing Pumpkins) Stubb's Waller Creek Amphitheater; Austin, TX, US
2017: (Billy Corgan) Madame ZuZu's; Highland Park, IL, US
2022: (The Smashing Pumpkins) Metro; Chicago, IL, US – First Metro show in 10 years and first with James Iha since the 2000 breakup
2024: (The Smashing Pumpkins) Oracle Park; San Francisco, CA, US

@@ Line 6: / Line 6: @@
 {{div col}}
 {{#cargo_query:
-tables=shows
+tables=shows, live_show_photos, live_show_videos
-|fields=_pageName=page_name, YEAR(date)=year, artist=artist, featuring_artist=featuring_artist, venue=venue, location=location, festival=festival, notes=notes
+|fields=shows._pageName=page_name, YEAR(shows.date)=year, 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=MONTH(date) = {{#if:{{{month|}}}|{{{month}}}|MONTH(NOW())}} AND DAYOFMONTH(date) = {{#if:{{{day|}}}|{{{day}}}|DAYOFMONTH(NOW())}}
+|join on=shows._pageName=live_show_photos._pageName, shows._pageName=live_show_videos._pageName
 |format=template
 |template=Live show row/Year