The node mask is:
Scarcely played new albums (4 tracks)|Filter:<Track Number><=4 and <Days Since Added><=60\<album|sort by:sum(played)|top:20|min tracks:3>
It should give me four tracks of those albums (max 20), that are made up of more than 3 tracks and that have not ben played but added recently to the library. MM starts the query and then freezes. After some time (e.g. a minute, but not always) MM gives me 6 error windows on top of each other, flashing, that I can't close and that say "...seems to be frozen").
Debug gives me nothing interesting:
Code: Select all
[2220] Node Scarcely played new albums (4 tracks) starting.
[2220] Node Scarcely played new albums (4 tracks) going to clear SongList.
[2220] Thread has started 1464
[2220] Thread registered, going to initialize 1464
[2220] Thread initialized 1464
[2220] 876 DB open SQL: SELECT Songs.*
[2220] FROM Songs
[2220] WHERE Songs.ID IN (SELECT Songs.ID FROM Songs WHERE (Cast(Songs.TrackNumber As integer)<=4 and CAST(julianday(date('now', 'localtime')) - julianday(date(Songs.DateAdded + julianday('1899-12-30'))) AS integer)<=60) AND Songs.Album IN (SELECT Songs.Album AS SortField0 FROM Songs WHERE Songs.Album <> '' AND (Cast(Songs.TrackNumber As integer)<=4 and CAST(julianday(date('now', 'localtime')) - julianday(date(Songs.DateAdded + julianday('1899-12-30'))) AS integer)<=60) AND ( NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%book%'))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%podcast%'))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%buch%'))) AND NOT (Songs.SongPath like '%Klassik%') AND NOT (Songs.SongPath like '%Stimmung%') AND NOT (Songs.SongPath like '%# Exoten%') ) GROUP BY Songs.Album HAVING Count(*) >= 3 ORDER BY CASE WHEN Min(Songs.PlayCounter) < 0 THEN -1 ELSE SUM(Songs.PlayCounter) END ASC, Songs.Album LIMIT 20) AND Songs.Album <> '' AND Songs.ID IN (SELECT Songs.ID FROM Songs, (SELECT Songs.Album AS CountField1 FROM Songs WHERE (Cast(Songs.TrackNumber As integer)<=4 and CAST(julianday(date('now', 'localtime')) - julianday(date(Songs.DateAdded + julianday('1899-12-30'))) AS integer)<=60) AND Songs.Album <> '' GROUP BY CountField1 HAVING Count(*) >= 3) AS CountTable0 WHERE (Cast(Songs.TrackNumber As integer)<=4 and CAST(julianday(date('now', 'localtime')) - julianday(date(Songs.DateAdded + julianday('1899-12-30'))) AS integer)<=60) AND Songs.Album = CountTable0.CountField1) AND ( NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%book%'))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%podcast%'))) AND NOT Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE (Genres.GenreName like '%buch%'))) AND NOT (Songs.SongPath like '%Klassik%') AND NOT (Songs.SongPath like '%Stimmung%') AND NOT (Songs.SongPath like '%# Exoten%') ))