Philip Meyer;512737 Wrote: > >Is there any logic that bypasses the track-by-track determination if > >there's an ALBUMARTIST given? I thought that having an ALBUMARIST > >pretty much said 'this album is a non-compilation'. > > > True. > > But then you have track_artists roles, not artist roles, I think, so > the count of artist roles on an album will be 0. > > i.e. SELECT COUNT(contributor) FROM contributor_album WHERE album = > a.id AND role = 1 > means the count will be 0, and thus the album is excluded.
On a track by track basis, you don't even have to do a query. If you're scanning tracks and a track has an ALBUMARTIST field, then skip all of the compilation determination queries and logic. I believe the only time a track with an ALBUMARTIST field would be part of a compilation is with either explicit COMPILATION=1 or ALBUMARTIST=Various Artists tagging. In which case it's also unnecessary to compare artists from all tracks. -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=74700 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
