Template:Venue performances: Difference between revisions
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
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, notes=Notes | ||
|where=shows.venue = "{{{1|{{PAGENAME}}}}}" {{#if:{{{location|}}}|AND location="{{{location}}}"}} | |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 | ||
Revision as of 04:14, 25 October 2020
No results