Hi Erland,
I have done the customise option and get the following. What I don't
know is what the syntax is. Do I duplicate the line:
tracks.id=excludecomments.track and excludecomments.value like
'duplicate'
and just change the word, or do add something like or 'altversion' on
the end?
-- PlaylistName:5 Star Songs
-- PlaylistGroups:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join comments as excludecomments on
tracks.id=excludecomments.track and excludecomments.value like
'duplicate'
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 excludecomments.id is null
and tracks.secs<420
and (track_statistics.rating>=90)
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-1209600)
group by tracks.id
order by rand()
limit 10;
Thanks for your help
CW
--
Chunkywizard
*Squeezebox:* Boom x2 (Lounge and Kitchen), Radio
*Server:* 7.4.2 for Windows Home Server (HP EX-475 MediaSmart Server
with 2GB RAM upgrade)
*Plugins:* Dynamic Playlists 2.8.1 | SQL Playlist 2.5 | Music
Information Screen 4.4.6 | Custom Scan 2.7.4 | TrackStat 2.10
*Remote:* iPod Touch Gen. 1 running 'iPeng'
(http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/)
*Music: *'Last.fm' (http://www.last.fm/user/chunkywizard)
------------------------------------------------------------------------
Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868
View this thread: http://forums.slimdevices.com/showthread.php?t=74512
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
