Hallo Ich rufe per mySQL die aktuelle Playlist ab ... leider habe ich nun bei der 6.5.3 ein Problem. Es werden manche doppelt angezeigt.
Mein Aufruf ist: SELECT tracks.id, tracks.titlesort as Title, Contributors.namesort as Interpret, a.titlesearch as Album, tracks.playCount, tracks.lastPlayed, tracks.url FROM albums a, Playlist_track INNER JOIN ((Contributors INNER JOIN (Contributor_track INNER JOIN Tracks ON Contributor_track.track = Tracks.id) ON Contributors.id = Contributor_track.contributor) INNER JOIN Albums ON Tracks.album = Albums.id) ON Playlist_track.track = Tracks.id WHERE tracks.album = a.id AND (((Playlist_track.playlist)= (SELECT Tracks.id FROM Tracks WHERE (((Tracks.url) Like 'clientplaylist://00:04:20:07:3a:b7'))))); findet jemand einen Fehler? ... oder hat jemand eine einfachere Abfrage? Danke -- unique24 ------------------------------------------------------------------------ unique24's Profile: http://forums.slimdevices.com/member.php?userid=9425 View this thread: http://forums.slimdevices.com/showthread.php?t=37398 _______________________________________________ slimserver-de mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/slimserver-de
