Template:Venue performances: Difference between revisions

Revision as of 07:09, 26 October 2020

No results

Poster	Date	Artist	Setlist	Photos	Banter	Notes

@@ Line 1: / Line 1: @@
+<templatestyles src="Template:Venue performances/styles.css" />
+{| class="wikitable sortable venue-performances"
+|-
+! Poster
+! Date
+! Artist
+! Setlist
+! Photos
+! Banter
+! Notes
+|-
 {{#cargo_query:
 tables=live_songs, shows, live_show_photos, live_banter
-|fields={{#if:{{{noposter|}}}||CONCAT("[[File:", shows.poster, "|200px|link=", shows._pageName, "]]")=Poster, }}CONCAT('[[', shows._pageName, '|', shows.date, ']]')=Date, shows.artist=Artist, IF(live_songs.name IS NULL, '', '[[File:OOjs_UI_icon_check-constructive.svg|30px|link=]]')=Setlist, IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, '', '[[File:OOjs_UI_icon_check-constructive.svg|30px|link=]]')=Photos, IF(live_banter._pageName IS NULL, '', '[[File:OOjs_UI_icon_check-constructive.svg|30px|link=]]')=Banter, notes=Notes
+|fields=shows.poster=poster, shows._pageName=page_name, shows.date=date, shows.artist=artist, shows.featuring_artist=featuring_artist, live_songs.name=setlist, IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, '', '1')=photos, live_banter._pageName=banter, notes=notes
 |where=shows.venue = "{{{1|{{PAGENAME}}}}}" {{#if:{{{location|}}}|AND location="{{{location}}}"}}
 |join on=shows._pageName = live_songs._pageName, shows._pageName=live_show_photos._pageName, shows._pageName=live_banter._pageName
@@ Line 8: / Line 19: @@
 |limit=250
 |offset=0
+|format=template
+|template=Template:Venue performances/Row
+|named args=yes
 }}
+|}