Template:Venue performances: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
tables=live_songs, shows, live_show_photos, live_banter | 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 | |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 | ||
|where=shows.venue = "{{{1|{{PAGENAME}}}}}" | |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 | |join on=shows._pageName = live_songs._pageName, shows._pageName=live_show_photos._pageName, shows._pageName=live_banter._pageName | ||
|group by=shows._pageName | |group by=shows._pageName |
Revision as of 21:14, 2 October 2020
No results