SELECT 
(SELECT Uri FROM "rdfs:Resource" WHERE ID = "url_u"), "title_u", "len_u", strftime ("%Y-%m-%dT%H:%M:%SZ", "creadate_u", "unixepoch"), "artnam_u", CAST ("sbpm_u" AS TEXT), "genre_u", CAST ("bpm_u" AS TEXT), "albtit_u", "ntrack_u", "com_u", strftime ("%Y-%m-%dT%H:%M:%SZ", "lastaddmod_u", "unixepoch") 
FROM 
(
SELECT * FROM(
	    SELECT t10_g."ntrack_u", t9_g."x_u", t9_g."artnam_u", t9_g."len_u", t9_g."artist_u", t9_g."url_u", t9_g."com_u", t9_g."bpm_u", t9_g."sbpm_u", 				t9_g."album_u", t9_g."title_u", t9_g."lastaddmod_u", t9_g."genre_u", t9_g."albtit_u", t9_g."creadate_u" 
	    FROM 
		(
		SELECT * FROM (
			SELECT t8_g."albtit_u", t8_g."album_u", t7_g."x_u", t7_g."artnam_u", t7_g."len_u", t7_g."artist_u", t7_g."url_u", t7_g."com_u", 				t7_g."bpm_u", t7_g."sbpm_u", t7_g."title_u", t7_g."lastaddmod_u", t7_g."genre_u", t7_g."creadate_u" FROM 
			    (
			    SELECT * FROM 
				(
				SELECT t6_g."artnam_u", t6_g."artist_u", t5_g."x_u", t5_g."len_u", t5_g."url_u", t5_g."com_u", t5_g."bpm_u", t5_g."sbpm_u", 						t5_g."title_u", t5_g."lastaddmod_u", t5_g."genre_u", t5_g."creadate_u" FROM 
				    (
				    SELECT * FROM 
					(SELECT t4_g."len_u", t3_g."x_u", t3_g."url_u", t3_g."com_u", t3_g."bpm_u", t3_g."sbpm_u", t3_g."title_u", 							t3_g."lastaddmod_u", t3_g."genre_u", t3_g."creadate_u" FROM 
					    (SELECT * FROM 
						(SELECT t2_g."bpm_u", t1_g."x_u", t1_g."url_u", t1_g."com_u", t1_g."sbpm_u", t1_g."title_u", 								t1_g."lastaddmod_u", t1_g."genre_u", t1_g."creadate_u" FROM 
						    (SELECT "nmm:MusicPiece1"."ID" AS "x_u", "nie:InformationElement2"."nie:isStoredAs" AS "url_u", 								"nie:InformationElement2"."nie:title" AS "title_u", "nie:InformationElement2"."nie:comment" AS 								"com_u", "nie:InformationElement2"."nie:contentCreated" AS "creadate_u", 								"rdfs:Resource3"."tracker:added" AS "lastaddmod_u", "nfo:Media4"."nfo:genre" AS "genre_u", 								"nfo:Media4"."nfo:averageBitrate" AS "sbpm_u" FROM "nmm:MusicPiece" AS "nmm:MusicPiece1", 								"nie:InformationElement" AS "nie:InformationElement2", "rdfs:Resource" AS "rdfs:Resource3", 								"nfo:Media" AS "nfo:Media4" WHERE "nmm:MusicPiece1"."ID" = "nie:InformationElement2"."ID" AND 								"nie:InformationElement2"."ID" = "rdfs:Resource3"."ID" AND "rdfs:Resource3"."ID" = "nfo:Media4"."ID"
						    )
						    AS t1_g LEFT JOIN 
						    (SELECT "nfo:Audio5"."ID" AS "x_u", "nfo:Audio5"."nfo:sampleRate" AS "bpm_u" FROM "nfo:Audio" AS 								"nfo:Audio5" WHERE "bpm_u" IS NOT NULL
						    )
						    AS t2_g ON t1_g."x_u" = t2_g."x_u"
						)
					    )
					    AS t3_g LEFT JOIN 
					    (SELECT "nmm:MusicPiece6"."ID" AS "x_u", "nmm:MusicPiece6"."nmm:length" AS "len_u" FROM "nmm:MusicPiece" AS 						"nmm:MusicPiece6" WHERE "len_u" IS NOT NULL
					    ) AS t4_g ON t3_g."x_u" = t4_g."x_u"
					)
				    ) AS t5_g LEFT JOIN
				    (SELECT "nmm:MusicPiece7"."ID" AS "x_u", "nmm:MusicPiece7"."nmm:performer" AS "artist_u", 						"nmm:Artist8"."nmm:artistName" AS "artnam_u" FROM "nmm:MusicPiece" AS "nmm:MusicPiece7", "nmm:Artist" AS 						"nmm:Artist8" WHERE "nmm:MusicPiece7"."nmm:performer" = "nmm:Artist8"."ID" AND "artnam_u" IS NOT NULL
				    )
				    AS t6_g ON t5_g."x_u" = t6_g."x_u"
				)
			    )
			    AS t7_g LEFT JOIN (
				SELECT "nmm:MusicPiece9"."ID" AS "x_u", "nmm:MusicPiece9"."nmm:musicAlbum" AS "album_u", 						"nmm:MusicAlbum10"."nmm:albumTitle" AS "albtit_u" FROM "nmm:MusicPiece" AS "nmm:MusicPiece9", "nmm:MusicAlbum" AS 						"nmm:MusicAlbum10" WHERE "nmm:MusicPiece9"."nmm:musicAlbum" = "nmm:MusicAlbum10"."ID" AND "albtit_u" IS NOT NULL
			    ) AS t8_g ON t7_g."x_u" = t8_g."x_u"
			)
		) AS t9_g
		LEFT JOIN (
		SELECT "nmm:MusicPiece11"."ID" AS "x_u", "nmm:MusicPiece11"."nmm:trackNumber" AS "ntrack_u" FROM "nmm:MusicPiece" AS "nmm:MusicPiece11" 			WHERE "ntrack_u" IS NOT NULL
		) AS t10_g ON t9_g."x_u" = t10_g."x_u"
	)
)
LIMIT ? OFFSET ?