Try this:
Code:
--------------------
-- 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%' or excludecomments.value like '%altversion%')
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;
--------------------
You can add more directives within the parentheses if you want more of
them, for example:
or excludecomments.value like '%some comment%'
If you want exact matches, you should instead use:
or excludecomments.value='some comment'
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=74512
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
