Template:DiskProducerSeriesGallery: Difference between revisions
Jump to navigation
Jump to search
Show disks with blank Series field. |
Escape single quotes in series name query condition. |
||
| Line 22: | Line 22: | ||
tables=Disks=D | tables=Disks=D | ||
|fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '|', D.Code, ']]', '<br>', D.Title) = Caption | |fields=D.CoverArt, D._pageName = Link, CONCAT('[[', D._pageName, '|', D.Code, ']]', '<br>', D.Title) = Caption | ||
|where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{{3}}}' | |where=D.Type = '{{{1}}}' AND D.Producer = '{{{2}}}' AND COALESCE(D.Series, 'Unsorted') = '{{#replace:{{{3}}}|'|''}}' | ||
|order by=D.SortableTitle, D.Code, D.Title | |order by=D.SortableTitle, D.Code, D.Title | ||
|limit=1000 | |limit=1000 | ||
Revision as of 04:27, 3 January 2025
This template creates a gallery for the disks in the given series. To list disks whose Series field is unset, use the special value Unsorted for parameter 3.
Usage:
{{DiskProducerSeriesGallery
| 1 = Type
| 2 = Producer
| 3 = Series
}}
Example result:
MIDI Game Music Series
