d6jg wrote: > I am convinced that primary_artist in tracks is key to the structure > these days. There is nothing else in tracks that associates a given > track to an artist except that and the album number. > > If I was to bet I would say that they LMS artist count is the sum of > unique artists in albums plus the number of unique primary_artists in > tracks. > > Edit. Yes to asking Michael.
The artist count in LMS equals to the number of entries in the contributors tables in my case (3354). And I believe that the contributors table is at the "center": from there it hooks the artists and the tracks through the contributors_artists and contributors_tracks tables. (I think). The strange thing is that I have 14809 entries in the contributors_tracks table. I would expect that the be equal to the number of tracks in LMS (14699)... argh... 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon ------------------------------------------------------------------------ Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
