Thank you erland, you're gem!
Here is my final code:
Code:
--------------------
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
-- PlaylistOptionDontRepeatTracks:1
-- PlaylistOptionUnlimited:1
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'
join albums on
tracks.album=albums.id
join genre_track on
tracks.id=genre_track.track
join genres on
genres.id=genre_track.genre
where
tracks.audio=1
and albums.title like 'BWV 988%'
and genres.name <> 'Zenph'
and tracks.tracknum = 7
and dynamicplaylist_history.id is null
group by tracks.id
order by genres.namesort, contributors.name;
--------------------
I have a little pb with you interface:
if I change the track number to '1' and click on 'test', it works.
but if I click on save and play, it plays the previous code (track 7).
after, if I execute the sql playlist, it would indeed play the track 1,
so the save function works.
Anyway, personnaly, I change the code directly on the file so it is not
an issue for me, just something a bit weird.
Cheers and thank you again!
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
