Template:Venue performances: Difference between revisions
MusikAnimal (talk | contribs) (Created page with "{{#cargo_query: tables=live_songs, shows, live_show_photos, live_banter |fields={{#if:{{{noposter|}}}||CONCAT("200px|link=", shows._pageName, "")=P...") |
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| | |where=shows.venue = "{{{1|{{PAGENAME}}}}}" | ||
|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 20:06, 2 October 2020
No results