w3wilkes wrote:
> Here's one I use for Christmas that was generated with SQL Playlists.
>
> >
Code:
--------------------
> > -- PlaylistName:Christmas Random Playlist
> -- PlaylistGroups:
> select tracks.url from tracks
> join genre_track on
> tracks.id=genre_track.track
> join genres on
> genre_track.genre=genres.id
> left join dynamicplaylist_history on
> tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> audio=1
> and dynamicplaylist_history.id is null
> and genres.name in ('Christmas')
> group by tracks.id
> order by random()
> limit 10;
--------------------
> >
Thank you! Saving this one.
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
