SELECT 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", t1_g."ntrack_u", t1_g."bpm_u", t1_g."len_u", t1_g."artnam_u", t1_g."albtit_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", 			"nmm:MusicPiece1"."nmm:trackNumber" AS "ntrack_u", (SELECT "nfo:Audio"."nfo:sampleRate" FROM "nfo:Audio" WHERE "nfo:Audio"."ID" = 			"nie:InformationElement2"."nie:isStoredAs") AS "bpm_u", "nmm:MusicPiece1"."nmm:length" AS "len_u", (SELECT "nmm:Artist"."nmm:artistName" FROM 			"nmm:Artist" WHERE "nmm:MusicPiece1"."nmm:performer" = "nmm:Artist"."ID") AS "artnam_u", (SELECT "nmm:MusicAlbum"."nmm:albumTitle" FROM 		"nmm:MusicAlbum" WHERE "nmm:MusicPiece1"."nmm:musicAlbum" = "nmm:MusicAlbum"."ID") AS "albtit_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