erland wrote: > Is the playlist definition you posted earlier a playlist which isn't > updated properly with the database dump files you send me earlier today > ? > http://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=747357&viewfull=1#post747357
Yes, that would work. In my troubleshooting I have tweaked it slightly though. This version makes comparing different versions of the same playlist much easier (given the sort order). "Rated 8+ 90 days" wrote: > > select tracks.id from tracks > join multilibrary_track on > tracks.id=multilibrary_track.track and > multilibrary_track.library=3 > join track_statistics on > tracks.url=track_statistics.url > where > audio=1 > and (track_statistics.rating>=80) > and > ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-7776000) > group by tracks.id > order by track_statistics.lastplayed asc > limit 5000 > ------------------------------------------------------------------------ prabbit's Profile: http://forums.slimdevices.com/member.php?userid=11142 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
