Hi!
After a few hours of trail end error I reliased that I need help. I want
a one click random playlist from a specific genre.
Here is a wild guess.
Code:
--------------------
-- PlaylistName:Jazz-Pop
-- PlaylistGroups:Soft
-- PlaylistCategory:songs
select genre_track.genre from genre_track
join tracks on
genre_track.track=tracks.id and genre.value like 'Jazz'
join tracks_persistent on
tracks_persistent.urlmd5 = tracks.urlmd5
left join dynamicplaylist_history on
dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and tracks.secs >= 'PlaylistTrackMinDuration'
and dynamicplaylist_history.id is null
and
case
when 'PlaylistParameter1'=1 then (tracks_persistent.playCount = 0 or
tracks_persistent.playCount is null)
when 'PlaylistParameter1'=2 then tracks_persistent.playCount > 0
else 1
end
order by random()
limit 'PlaylistLimit';
--------------------
SB Touch optical to Hegel H90, Speakers Larsen 4.2
Spare SB3
AirPlay Bridge to Audio Pro A10
Squeezelite-x connected to home LMS with ZeroTier One.
SB Radio
ReadyNAS 202
iPeng
------------------------------------------------------------------------
bernt's Profile: http://forums.slimdevices.com/member.php?userid=1342
View this thread: http://forums.slimdevices.com/showthread.php?t=115073
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
