Hi, hope somebody can help me out! When I want to start the Dynamic
Playlist "Top Rated for Artist", the feedback form is populated with a
horrible long list that als contains all the Composers:
17905.
This doesn't happen when I browse the Artist list in the Webview or on
any of my Squeezebox devices -- of course, because these are my
settings:
17906
What I've already tried is editing the raw SQL for the
topratedforartist.sql.xml:
Code:
--------------------
-- PlaylistName:Top rated for artist
-- PlaylistGroups:
-- PlaylistParameter1:artist:Select artist:
select tracks.url from tracks
join contributor_track on
tracks.id=contributor_track.track and
contributor_track.contributor='PlaylistParameter1'
join track_statistics on
tracks.url=track_statistics.url
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 track_statistics.rating>=70
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-10800)
group by tracks.id
order by random()
limit 10;
--------------------
But unfortunately I can't get it to work. I know the solution has
something to do with narrowing down the Contributors table with
something like this:
Code:
--------------------
If you only wanted the contributors that have the role "artist", "album
artist" or "track artist", you would instead use a query like:
select contributors.* from contributors, contributor_album
where
contributors.id = contributor_album.contributor and
contributor_album.role in (1, 5, 6)
group by contributors.id
order by contributors.namesort
--------------------
(from
http://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure#Get_artists_in_the_database)
Thanks in advance!
Randy
+-------------------------------------------------------------------+
|Filename: screen2..png |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=17906|
+-------------------------------------------------------------------+
1x Squeezebox Classic / 2x Squeezebox Radio / LMS 7.9.0 - 1403985527 on
HP Proliant N54L with Ubuntu 12.04 LTS / OrangeSqueeze
http://www.last.fm/user/rndr
------------------------------------------------------------------------
rlem's Profile: http://forums.slimdevices.com/member.php?userid=46931
View this thread: http://forums.slimdevices.com/showthread.php?t=103496
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
