Template:Today in history: Difference between revisions

VisualWikitext

Latest revision as of 00:38, 5 November 2023

Releases

2022: "Beguiled" was released in Worldwide (Digital)
2022: The music video for "Beguiled" was released

Charts

1998: Celebrity Skin peaked at #4 on the Australian Albums (ARIA) chart

Live shows[edit source]

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 1: / Line 1: @@
-{{#vardefine:birthdays|{{#invoke:Today in history|birthdays|{{CURRENTMONTH}}|{{CURRENTDAY2}}}}}}{{#if:{{#var:birthdays}}|
+{{#invoke:Today in history|birthdays|{{{month|{{CURRENTMONTH}}}}}|{{{day|{{CURRENTDAY2}}}}}}}{{#invoke:Today in history|releases|{{{month|{{CURRENTMONTH}}}}}|{{{day|{{CURRENTDAY2}}}}}}}{{#invoke:Today in history|certifications|{{{month|{{CURRENTMONTH}}}}}|{{{day|{{CURRENTDAY2}}}}}}}{{#invoke:Today in history|charts|{{{month|{{CURRENTMONTH}}}}}|{{{day|{{CURRENTDAY2}}}}}}}
-=== Birthdays ===
+==== Live shows ====
-<code>{{#var:birthdays}}</code>
+{{div col}}
-}}{{#vardefine:releases|{{#invoke:Today in history|releases|{{CURRENTMONTH}}|{{CURRENTDAY2}}}}}}
-{{#if:{{#var:releases}}|
-=== Releases ===
-{{#var:releases}}
-}}
-=== Live shows ===
 {{#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, 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) = MONTH(NOW()) AND DAYOFMONTH(date) = DAYOFMONTH(NOW())
+|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
 |named args=yes
+|order by=year ASC
 }}
+{{div col end}}