Song disks: Difference between revisions
Jump to navigation
Jump to search
(Extract main vendor from list of production companies.) |
(Workaround for escaped HTML entities being printed.) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Disks = D | tables=Disks=D | ||
|fields= | |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= | |||
|limit=2000 | |limit=2000 | ||
|format=table | |format=table | ||
|merge similar cells=yes | |merge similar cells=yes | ||
}} | }} | ||