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;
--------------------



Main system - Rock Solid with LMS 8.2.0 on WHS 2011 - 2 Duets and
Squeeseslave
Cabin system - Rock solid with LMS 8.2.0 on Win10 Pro - 1 RPi 3 Model
B/Hifiberry DAC+ Pro/PiCorePlayer and Squeezeslave
Squeezebox Boom - "At Large" player around both home and cabin
Headphones and car - Android phone/Bluetooth w/full library on MicroSD
card - PowerAmp music player app (similar to Material Skin)
------------------------------------------------------------------------
w3wilkes's Profile: http://forums.slimdevices.com/member.php?userid=22973
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

Reply via email to