Sorry, one more question -
I have an album (Balkanica! by dunkelbunkt)
One track (5) is present, as are 2 others (without track numbers).
This hasn't been picked up by the incomplete album finder nodes.
Code: Select all
<Group|Name:Albums...|Show tracks:No>\Incomplete Albums (Bex's algorithm)|SQL Filter:Songs.IDAlbum IN (SELECT IDAlbum FROM (SELECT Songs.IDAlbum IDAlbum FROM Songs, (SELECT IDAlbum, SUM(Non3Digits) AS CountNon3Digits, SUM(Cnt) AS Cont FROM (SELECT IDAlbum, COUNT(CASE WHEN Length(TrackNumber) = 3 THEN NULL ELSE 1 END) as Non3Digits, COUNT(*) AS Cnt, COUNT(CASE WHEN TrackNumber = '' THEN NULL ELSE 1 END) AS NonBlanks, MAX(Cast(TrackNumber as INTEGER)) AS MaxNr, COUNT(CASE WHEN SongLength >= 2400000 THEN 1 ELSE NULL END) AS SngLngth FROM Songs WHERE IDAlbum > 0 GROUP BY IDAlbum, TrackNumber) AS Inline1 GROUP BY IDAlbum HAVING COUNT(*) = SUM(Cnt) AND SUM(Cnt) = SUM(NonBlanks) AND MAX(MaxNr) > SUM(Cnt) AND (SUM(SngLngth) > 0 OR SUM(Cnt) >= 2)) Inline2 WHERE Songs.IDAlbum = Inline2.IDAlbum AND Songs.IDAlbum > 0 GROUP BY Songs.IDAlbum, CASE WHEN CountNon3Digits = 0 THEN Substr(TrackNumber, 1, 1) ELSE '0' END HAVING Cast(Substr(MIN(TrackNumber), -2, 2) as INTEGER) || (MAX(Cast(TrackNumber as INTEGER)) - MIN(Cast(TrackNumber as INTEGER)) + 1 - COUNT(*)) <> '10' AND MAX(cast(TrackNumber as INTEGER)) >= COUNT(*)) GROUP BY IDAlbum)\<Album with album artist|Statistic:Count(Tracks), Max(Track Number)>
Any ideas why? ANy adjustments to the mask that can be made (or advice on another approach)