My custom SQL Playlist to achieve this was:

-- PlaylistName:Not Rated Songs for album
-- PlaylistGroups:Songs, Not Rated
-- PlaylistParameter1:album:Select album:
SELECT tracks.url
FROM tracks
WHERE
  audio=1
  AND tracks.album='PlaylistParameter1'
  AND NOT EXISTS (SELECT 1 FROM track_statistics WHERE 
tracks.url=track_statistics.url AND track_statistics.rating IS NOT NULL)
  AND NOT EXISTS (SELECT 1 FROM dynamicplaylist_history WHERE 
tracks.id=dynamicplaylist_history.id)

Erland - is there a way to get/use the current player id in a SQL Playlist?  
This SQL is filtering out any songs in the dynamic playlist history for any 
player, where actually it would be nice to only ignore songs that are in the 
history for the current player.  I looked in the wiki and couldn't see any 
keyword, but the table does record dynamic playlist history per-player.

Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins

Reply via email to