..may I jump in here?
Hello everybody.
I am new here.
Thank you all very much for 3rd party plugins
I am discovering some
amazing stuff.
Erland thanks a lot for SQL Playlist !!!
one of best nerd-pluggies here, especially if you dig into sql-code
:)
I already built a few very simple SQL playlists work fine!!
But I got a problem on one, which I thought should actually be easy:
I want to rebuild this very simple dynamic playlist from foobar:
Performer HAS ctop
In foobar I use variable performer as flag-variable, to create
dynamic playlist for my current top tracks (ctop) every current
favourite tune gets this ctop flag
dont use performer otherwise
(yes, its a misuse of this variable, but I am not that eager, to create
new tag-variables)
I guess solution to get this from Squeezebox database has something to
do with table Contributor
but which variable?
I tried this below ..well, test was successful regarding the code
syntax
but no results either?? so must be something wrong.
-- PlaylistName:CURRENT TOPS!!! (flag in performer)
-- PlaylistGroups:
select tracks.url from tracks
join contributor_track on
tracks.id=contributor_track.track
-- and contributor_track.role in (3)
join contributors on
contributor_track.track=contributors.id
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
and contributors.name like 'ctop'
group by tracks.id
order by rand()
limit 20;
Can anybody help me on this, please?
it should be very easy, shouldnt
it?! :-/
Cheers.
PS.
I am not an huge SQL expert,
just copying.
but my biggest problem is that I dont understand / dont know the
database structure (I know there is a wiki, but it seems to be
incomplete)
--
prinzenrolle
------------------------------------------------------------------------
prinzenrolle's Profile: http://forums.slimdevices.com/member.php?userid=39407
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
