Template:Today in history: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
(13 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{#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}}}}}}} | |||
{{#invoke:Today in history|birthdays|{{CURRENTMONTH}}|{{CURRENTDAY2}}}} | ==== Live shows ==== | ||
{{div col}} | |||
{{#invoke:Today in history|releases|{{CURRENTMONTH}}|{{CURRENTDAY2}}}} | |||
=== Live shows === | |||
{{#cargo_query: | {{#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 | |format=template | ||
|template=Live show row/Year | |template=Live show row/Year | ||
|named args=yes | |named args=yes | ||
|order by=year ASC | |||
}} | }} | ||
{{div col end}} |
Latest revision as of 00:38, 5 November 2023
Charts
- 1998: "Perfect" peaked at #2 on the Canada Rock/Alternative (RPM) chart
- 2000: "Try, Try, Try" peaked at #36 on the Italy (FIMI) chart
Live shows[edit source]
- 1993: (The Smashing Pumpkins) Rock City (venue); Nottingham, UK
- 2000: (The Smashing Pumpkins) Ballsporthalle; Frankfurt, DE
- 2007: (The Smashing Pumpkins) The Amphitheater at Clark County; Ridgefield, WA, US
- 2010: (The Smashing Pumpkins) Warehouse Live; Houston, TX, US
- 2017: (Billy Corgan) Madame ZuZu's; Highland Park, IL, US
- 2024: (The Smashing Pumpkins) Grand Sierra Resort; Reno, NV, US