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
