Song disks - Revision history

Midiphile: Undo revision 2266 by Midiphile, no longer needed after escape fixes in Cargo.

2025-07-03T04:20:00Z

Undo revision 2266 by Midiphile, no longer needed after escape fixes in Cargo.

← Older revision		Revision as of 04:20, 3 July 2025
Line 1:		Line 1:
	{{#cargo_query:		{{#cargo_query:
	tables=Disks=D		tables=Disks=D
	\|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		\|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.Series, D.SortableTitle, D.Code, D.Title		\|order by=D.Producer, D.Series, D.SortableTitle, D.Code, D.Title

Midiphile: Workaround for escaped HTML entities being printed.

2025-01-03T05:02:50Z

Workaround for escaped HTML entities being printed.

← Older revision		Revision as of 05:02, 3 January 2025
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

Midiphile: Sort by series after producer.

2024-03-18T14:46:16Z

Sort by series after producer.

← Older revision		Revision as of 14:46, 18 March 2024
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~~, D.Series~~, CONCAT('', D.ReleaseYear) = Year, D.CoProduction = Co-production, D.Programming		\|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
	}}		}}

Midiphile: Us main and co-producer fields.

2024-03-15T01:29:01Z

Us main and co-producer fields.

← Older revision		Revision as of 01:29, 15 March 2024
Line 1:		Line 1:
	{{#cargo_query:		{{#cargo_query:
	tables=Disks = D~~, Disks__Production = DP1~~		tables=Disks=D
	\|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		\|fields=D.Producer, CONCAT('[[', D._pageName, '\|', D.Code, ']]') = Code , CONCAT('[[', D._pageName, '\|', D.Title, ']]') = Title, D.Series, CONCAT('', D.ReleaseYear) = Year, D.CoProduction = Co-production, D.Programming
	~~\|join on=D._ID = DP1._rowID~~		\|where=D.Type = 'Songs'
	\|where=D.Type = 'Songs' ~~AND DP1._position = 1~~		\|order by=D.Producer, D.SortableTitle, D.Code, D.Title
	\|order by=~~Vendor~~, D.SortableTitle ~~ASC~~
	\|limit=2000		\|limit=2000
	\|format=table		\|format=table
	\|merge similar cells=yes		\|merge similar cells=yes
	}}		}}

Midiphile: Extract main vendor from list of production companies.

2024-03-14T16:18:55Z

Extract main vendor from list of production companies.

← Older revision		Revision as of 16:18, 14 March 2024
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
	}}		}}

Midiphile: All song disks as table.

2024-03-14T06:30:42Z

All song disks as table.

New page

{{#cargo_query:
tables=Disks
|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
|where=Disks.Type = 'Songs'
|order by=Vendor, Disks.SortableTitle ASC
|limit=2000
|format=table
|merge similar cells=yes
}}