hi
I just installed dynamic playlist and sql playlist, and i'm trying to
use it with a custom sql query.
what I want is playing randomly all songs of a specific playlist whose
play count is 1
here is the sql :
-- PlaylistName: random played once
-- PlaylistGroups:
select tracks.url from tracks
join tracks_persistent on
tracks.url=tracks_persistent.url
join playlist_track on
tracks.url=playlist_track.track and
playlist_track.playlist=(select max(playlist) from
playlist_track,tracks where
playlist_track.playlist=tracks.id and
tracks.title='mylist'
group by playlist_track.playlist)
where
audio=1
and tracks_persistent.playCount=1
group by tracks.id
order by random()
limit 10;
from withing the web interface on PC, when I hit 'Test' below the sql
query window, i get tracks as result after a few seconds of processing
but then, when I save this dynamic playlist, and try to run it from my
squeezebox radio, touch, or from within web interface, it says the
playlist is empty
what is wrong in there ?
thanks
------------------------------------------------------------------------
palaga's Profile: http://forums.slimdevices.com/member.php?userid=56795
View this thread: http://forums.slimdevices.com/showthread.php?t=95950
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
