Wow, it looks like this works - thanks Br@m!
br@m wrote: > There's a table in the database that keeps track of the last time a song > was played, *-tracks_persistent-*. > > I include this code in SQL playlists to leave out tracks played in the > last 4 days: > > > Code: -------------------- > > > where not exists ( > select * > from tracks_persistent tp > where tp.urlmd5 = tracks.urlmd5 > and datetime( tp.lastPlayed, 'unixepoch' ) < datetime( 'now' ) > and datetime( tp.lastPlayed, 'unixepoch' ) > datetime( 'now' , 'start of day' , '-4 days' ) > ) > -------------------- > > 1x Classic / 2x Radio / 2x Receiver / 1x DAC32 / LMS 8.3.0 - 1630708871 on Docker / Ubuntu 18.04 LTS http://www.last.fm/user/rndr ------------------------------------------------------------------------ rlem's Profile: http://forums.slimdevices.com/member.php?userid=46931 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
