MeSue;637294 Wrote:
> Can anyone help me with the parameters for a custom SQL playlist?
> I want songs rated 3 that have been played less than 5 times (random
> selection).
>
> Thanks!
Not sure about parameters but plain SQL works OK.
Might not be the correct/best way, but this seems to work for me:
Code:
--------------------
-- PlaylistName:Rated 3 and played less than 5 times
-- PlaylistGroups:
select tracks.url from tracks
left join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and track_statistics.rating=60
and track_statistics.playCount < 5
order by rand()
limit 10;
--------------------
--
MillmoorRon
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
