|
|
| Line 1: |
Line 1: |
| <templatestyles src="Template:Live performances by date/styles.css" /> | | <templatestyles src="Template:Live performances by date/styles.css" /> |
| {| class="wikitable sortable live-performances"
| | {{#invoke:Live performances by date|main|{{{artist|}}}|{{{tour|}}}|{{{year|}}}|{{{festival|}}}|{{{noposter|}}}}} |
| |-
| |
| {{#if:{{{noposter|}}}|| | |
| | |
| {{!!}} Poster}}
| |
| ! Date
| |
| {{#if:{{{artist|{{{tour|}}}}}}||
| |
| | |
| {{!!}} Artist}}
| |
| ! Venue
| |
| ! Location
| |
| ! Setlist
| |
| ! Photos
| |
| ! Banter
| |
| |- | |
| {{#cargo_query:
| |
| tables=shows, live_show_photos, live_songs, live_banter
| |
| |fields={{#if:{{{noposter|}}}|'yes'=noposter,|shows.poster=poster,}} shows._pageName=page_name, (CASE WHEN shows.date__precision = 1 THEN shows.date WHEN shows.date__precision = 2 THEN DATE_FORMAT(shows.date, '%Y-%d-XX') ELSE DATE_FORMAT(shows.date, '%Y-XX-XX') END)=date, {{#if:{{{artist|{{{tour|}}}}}}||shows.artist=artist, shows.featuring_artist=featuring_artist,}} shows.venue=venue, shows.venue_wikitext=venue_wikitext, shows.location=location, live_songs.name=setlist, IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, '', '1')=photos, live_banter._pageName=banter | |
| |where={{#invoke:String|join| AND |{{#if:{{{tour|}}}|shows.tour="{{{tour}}}"}}|{{#if:{{{artist|}}}|(shows.artist="{{{artist}}}" OR shows.featuring_artist="{{{artist|}}}")}}|{{#if:{{{year|}}}|YEAR(shows.date)={{{year}}}}}|{{#if:{{{festival|}}}|shows.festival="{{{festival}}}"}}}}
| |
| |join on=shows._pageName = live_songs._pageName, shows._pageName=live_show_photos._pageName, shows._pageName=live_banter._pageName
| |
| |group by=shows._pageName
| |
| |order by=shows.date ASC
| |
| |limit=250
| |
| |offset=0
| |
| |format=template
| |
| |template=Template:Live performances by date/Row
| |
| |named args=yes
| |
| }} | |
| |}
| |
