SilverRS8;516013 Wrote: > I thought you'd do some investigation on a smaller subset to see if > there are differences and where they actually are? > > ACC performs a query with the following joins: > > join contributors AS album_artist on > albums.contributor=album_artist.id > left join tracks on tracks.album=albums.id > left join genre_track on genre_track.track=tracks.id > left join genres on genre_track.genre=genres.id > join contributor_track ON tracks.id = contributor_track.track and > contributor_track.role in (1,6) > join contributors AS track_artist on contributor_track.contributor = > track_artist.id > > So this also means that if certain tags are not used, they will not be > included in the query results. So I suspect that you have a number of > tracks (43,202 minus 41707 to be exactly) which are not tagged fully. > > Frank
Oops, my bad, I will try narrowing it down in smaller groups. Not sure what all the coding is, but I will say every track has an ARTIST tag. Individuals (and those with guests) use ARTISTSORT as well. Does any of that mean anything to you as we try to track it down? ...thanks for the willingness to dig into this - it will be a Perfect tool for me once we get it sorted out. :-) -- fphredd ------------------------------------------------------------------------ fphredd's Profile: http://forums.slimdevices.com/member.php?userid=33133 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
