I've got this SQLPayList working against SlimServer 6.2.1 on Windows XP
running against a MySQL 4.1 back end. My database is linked to iTunes 5
and rescans nightly.
I've built a playlist file as follows:
Code:
--------------------
-- PlaylistName: Unplayed Music
SELECT t.url /* , t.title, g.name, t.playCount */
FROM tracks t
LEFT JOIN genre_track gt ON t.id = gt.track
LEFT JOIN genres g ON gt.genre = g.id
WHERE g.name NOT IN ('Classical','Books & Spoken','Podcast','Musicals')
AND t.playcount is null
ORDER by rand() limit 10;
--------------------
It seems to work fine except that all playcount values in the tracks
table are null.
Should the playcount values be coming from iTunes? Or am I missing
something else?
Thanks for any help.
--
barcar
------------------------------------------------------------------------
barcar's Profile: http://forums.slimdevices.com/member.php?userid=1760
View this thread: http://forums.slimdevices.com/showthread.php?t=20533
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
