Pommes wrote: 
> It is working now, heres the complete sql text, which works in Erlands
> great Plugin SQL Playlist:
> 
> -- PlaylistName:DANCE PARTY
> -- PlaylistGroups:
> select tracks.url from tracks
>       left join dynamicplaylist_history on
>               tracks.id=dynamicplaylist_history.id and
> dynamicplaylist_history.client='PlaylistPlayer'
>       join albums on
>               tracks.album=albums.id and
>               albums.title LIKE '%DANCE%'
> OR
> 
> tracks.album=albums.id and
>               albums.title LIKE '%PARTY%'
>       
>       where
>               tracks.audio=1
>               and dynamicplaylist_history.id is null
>       group by tracks.id
>       order by random()
>       limit 10;
> 
> 
> Thank you for the right hint!
> 
> Regards
> Pommes

:)



LMS 8.0 on PC, Xubuntu 20.04, FLACs 16->24 bit, 44.1->192kbps.  2
Touches & EDO.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (A308CR amp & ESLs) & Marantz
CR603 UPnP renderers.  
Also Minimserver & Upplay to same & to upmpdcli/mpd PC renderers.  
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.  
Wireless Xubuntu 20.04 laptop firefox/upplay or Android mobile with
Squeeze-Ctrl/BubbleUPnP controls LMS/Minimserver.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=109825

_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Reply via email to