bernt wrote:
> Don't know anything about SQL. Tried this but it does not do anything.
>
>
> >
Code:
--------------------
> > -- PlaylistName:Test
> -- PlaylistGroups:
> select tracks.url from tracks
> left join dynamicplaylist_history on
> tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> audio=1
> and tracks.album like '%Hits%'
> and dynamicplaylist_history.id is null
> group by tracks.id
> order by random()
> limit 10;
>
--------------------
> >
tracks.album isn't the album name. You need to create a join between
tracks and albums using the tracks.album and album.id fields and then
inspect the album.title field. SQL has quite a steep learning curve.
Something like this may work (untested)
Code:
--------------------
-- PlaylistName:Test
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and tracks.album = albums.id
and albums.title like '%Hits%'
and dynamicplaylist_history.id is null
group by tracks.id
order by random()
limit 10;
--------------------
LMS 7.9 on VortexBox Midi box, Xubuntu 16.04, FLACs 16->24 bit,
44.1->192kbps.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to A308CR amp & ESLs) &
Marantz CR603 UPnP renderers.
Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC
renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 16.04 laptop firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver.
Also a Touch with EDO, plus spare, unused.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
