Song disks: Difference between revisions
Jump to navigation
Jump to search
(Us main and co-producer fields.) |
(Sort by series after producer.) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Disks=D | tables=Disks=D | ||
|fields=D.Producer, CONCAT('[[', D._pageName, '|', D.Code, ']]') = Code , CONCAT('[[', D._pageName, '|', D.Title, ']]') = Title | |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 | ||
|where=D.Type = 'Songs' | |where=D.Type = 'Songs' | ||
|order by=D.Producer, D.SortableTitle, D.Code, D.Title | |order by=D.Producer, D.Series, D.SortableTitle, D.Code, D.Title | ||
|limit=2000 | |limit=2000 | ||
|format=table | |format=table | ||
|merge similar cells=yes | |merge similar cells=yes | ||
}} | }} | ||