Song disks: Difference between revisions

From Midipedia
Jump to navigation Jump to search
(All song disks as table.)
 
(Extract main vendor from list of production companies.)
Line 1: Line 1:
{{#cargo_query:
{{#cargo_query:
tables=Disks
tables=Disks = D, Disks__Production = DP1
|fields=Disks.Production = Vendor, CONCAT('[[', Disks._pageName, '|', Disks.Code, ']]') = Code , CONCAT('[[', Disks._pageName, '|', Disks.Title, ']]') = Title, Disks.Series, CONCAT('', Disks.ReleaseYear) = Year, Disks.Production = Co-production, Disks.Programming
|fields=CONCAT('[[', DP1._value, ']]') = Vendor, CONCAT('[[', D._pageName, '|', D.Code, ']]') = Code , CONCAT('[[', D._pageName, '|', D.Title, ']]') = Title, D.Series, CONCAT('', D.ReleaseYear) = Year, D.Production = Co-production, D.Programming
|where=Disks.Type = 'Songs'
|join on=D._ID = DP1._rowID
|order by=Vendor, Disks.SortableTitle ASC
|where=D.Type = 'Songs' AND DP1._position = 1
|order by=Vendor, D.SortableTitle ASC
|limit=2000
|limit=2000
|format=table
|format=table
|merge similar cells=yes
|merge similar cells=yes
}}
}}

Revision as of 16:18, 14 March 2024

Error: No field named "Production" found for the database table "Disks".
Retrieved from "https://midipedia.org:443/w/index.php?title=Song_disks&oldid=118"