Whoops sorry one more problem.
I modified the script and added some more artists but it only pulls a
subset of the ones I gave it. I changed the list like so:
-- PlaylistName:Bun Artists
-- PlaylistGroups:
select tracks.url from tracks
join contributor_track on
tracks.id=contributor_track.track
join contributors on
contributor_track.contributor=contributors.id
and contributor_track.role in (1,5)
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 in ('Lyle Lovett')
or contributors.name in ('Guy Clark')
or contributors.name in ('Crosby, Stills & Nash')
or contributors.name in ('Townes Van Zandt')
or contributors.name in ('Cowboy Junkies')
or contributors.name in ('Tom Waits')
or contributors.name in ('Richard Thompson')
or contributors.name in ('Sammi Smith')
or contributors.name in ('Emmylou Harris')
or contributors.name in ('Gram Parsons')
or contributors.name in ('Warren Zevon')
or contributors.name in ('Jackson Browne')
or contributors.name in ('Joni Mitchell')
order by random()
limit 10;
Yet SQL playlist only gives it half the artists:
[12-09-16 14:08:30.0927]
Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1058) Executing:
select tracks.url from tracks join contributor_track on
tracks.id=contributor_track.track join contributors on
contributor_track.contributor=contributors.id and contributor_track.role
in (1,5) left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:16:5f:4a' where audio=1 and
dynamicplaylist_history.id is null and contributors.name in ('Lyle
Lovett') or contributors.name in ('Guy Clark') or contributors.name in
('Crosby, Stills & Nash') or contributors.name in ('Townes Van Zandt')
or contributors.name in ('Cowboy Junkies') or contributors.name in
('Sammi Smith') order by random() limit 10;
[12-09-16 14:08:31.2926]
Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1065) Executing and
collecting: select tracks.url from tracks join contributor_track on
tracks.id=contributor_track.track join contributors on
contributor_track.contributor=contributors.id and contributor_track.role
in (1,5) left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:16:5f:4a' where audio=1 and
dynamicplaylist_history.id is null and contributors.name in ('Lyle
Lovett') or contributors.name in ('Guy Clark') or contributors.name in
('Crosby, Stills & Nash') or contributors.name in ('Townes Van Zandt')
or contributors.name in ('Cowboy Junkies') or contributors.name in
('Sammi Smith') order by random() limit 10;
I'm digging through
http://wiki.erland.isaksson.info/index.php/SQL_Playlist_plugin but I
haven't seen yet why its not putting in all the artists.
------------------------------------------------------------------------
sander's Profile: http://forums.slimdevices.com/member.php?userid=10737
View this thread: http://forums.slimdevices.com/showthread.php?t=96456
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
