Also die aktuelle Playlist sowie die gespeicherten Playlisten habe ich.
Problem ist aber noch die Abfrage der aktuellen Playlist mit Titel und
Interpret
Code:
--------------------
SELECT p.id, p.`position`, t.titlesort,t.secs FROM playlist_track p,
contributor_track c, contributors cs, albums a, tracks t
LEFT JOIN tracks ON t.id = p.track
WHERE p.playlist = (sELECT id FROM tracks where content_type = 'cpl' AND
url='clientplaylist://00:04:20:07:3a:b7') and p.track=c.track AND
c.contributor=cs.id AND t.album=a.id
ORDER BY p.playlist, p.`position`;
--------------------
hier erhalte ich den Fehler "Unknown column 'p.track' in 'on clause'"
ich möchte gerne von der aktuellen Playlist ((sELECT id FROM tracks
where content_type = 'cpl' AND
url='clientplaylist://00:04:20:07:3a:b7')) nicht die ID Tracks, sondern
Titel und Interpret.
Bei den Songs habe ich:
Code:
--------------------
SELECT t.id, t.titlesearch as Title, cs.namesearch as Interpret,
a.titlesearch as Album, t.playCount, t.lastPlayed, t.url FROM tracks t,
contributor_track c, contributors cs, albums a WHERE t.id=c.track AND
c.contributor=cs.id AND t.album=a.id order by cs.namesearch;
--------------------
Kann aber beide nicht vereinen ... schafft es jemand hier?
Danke
Hannes
--
unique24
------------------------------------------------------------------------
unique24's Profile: http://forums.slimdevices.com/member.php?userid=9425
View this thread: http://forums.slimdevices.com/showthread.php?t=33623
_______________________________________________
slimserver-de mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/slimserver-de
