Saughassy;610513 Wrote:
> Dear Erland! (or anyone who can help me:)
>
> How can i create a dynamic playlist with these parameters?
>
> Some kind of genres exclude
> top rated
> least played
>
> Thanks,
> Peter
Not exactly what you're after but it might give you some ideas!
You could use custom skip filters to exclude multiple genres?
Code:
--------------------
-- PlaylistName:Favourites least played by Genre...
-- PlaylistGroups:Favourites...
-- PlaylistParameter1:genre:Select genre:
select tracks.url from tracks
join genre_track on
tracks.id=genre_track.track
and genre_track.genre='PlaylistParameter1'
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
and dynamicplaylist_history.client='PlaylistPlayer'
left join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and track_statistics.rating>70
and dynamicplaylist_history.id is null
order by track_statistics.playCount asc
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