Song disks: Difference between revisions
Jump to navigation
Jump to search
(Sort by series after producer.) |
(Workaround for escaped HTML entities being printed.) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Disks=D | tables=Disks=D | ||
|fields=D.Producer, D.Series, CONCAT('[[', D._pageName, '|', D.Code, ']]') = Code , CONCAT('[[', D._pageName, '|', D.Title, ']]') = Title, CONCAT('', D.ReleaseYear) = Year, D.CoProduction = Co-production, D.Programming | |fields=D.Producer, REPLACE(D.Series, '''', '''') = Series, CONCAT('[[', D._pageName, '|', D.Code, ']]') = Code , CONCAT('[[', D._pageName, '|', D.Title, ']]') = Title, CONCAT('', D.ReleaseYear) = Year, D.CoProduction = Co-production, D.Programming | ||
|where=D.Type = 'Songs' | |where=D.Type = 'Songs' | ||
|order by=D.Producer, D.Series, D.SortableTitle, D.Code, D.Title | |order by=D.Producer, D.Series, D.SortableTitle, D.Code, D.Title | ||