erland;648589 Wrote: > Create a free from query with the following SQL: > > Code: -------------------- > > > select tracks.title,tracks.url from tracks,tracks_persistent where tracks.url=tracks_persistent.url and audio=1 and (playcount=0 or playcount is null) > -------------------- > > > > I think that should give you what you want.
Hi Erland, in your SQL what does playcount is null actually mean? I have a number of tracks by The Cult which playcount is null for. If I edit the statement and take this out then it shows they all have playcount>0. Are some of my TrackStats damaged? CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Office), Radio (with battery) *Server:* 7.6.1 for Windows Home Server (HP EX-490 MediaSmart Server) *Plugins:* Dynamic Playlists 2.8.4 | SQL Playlist 2.5.3359 | Music Information Screen 4.4.7 | Custom Scan 2.83378 | TrackStat 2.10.3366 | Album Review 2.9.5 | Biography 2.9.4 *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=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins