PasTim wrote:
> How much SQL do you know? If you start from the 'Random Albums' sql you
> need to select tracks where the Albums title field is 'like' the words
> you want. This isn't the place to give a tutorial on sql, but that may
> give you a start :)
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;
--------------------
SB Touch to Yamaha A-S501, Boston Acoustics A26.
SB 3 to Audio Pro T3.
SB BOOM
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=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
