Hi erland,
thx for your precious help.
this works:
Code:
--------------------
-- PlaylistName:Goldberg Variations
-- 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 'BWV 988%' and albums.title not like '%Zenph%'
and (tracks.tracknum = 27)
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand();
--------------------
but... I'd like to sort the items by genre. I tried to link the genre
tables but did not succeed, if u can help...
Cheers :)
Pat
--
PatLogan
------------------------------------------------------------------------
PatLogan's Profile: http://forums.slimdevices.com/member.php?userid=30840
View this thread: http://forums.slimdevices.com/showthread.php?t=76244
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
