pkfox wrote: > Hi there, thanks for your feedback , I'm looking into it now - it > appears that not all contributors are linked to either an album or a > track if you run the query below you will probably see the missing > records > > > Code: -------------------- > > > select * from contributors > left join albums > on contributors.id = albums.contributor > left join tracks > on tracks.album = albums.id > where contributors.id not in > (select contributors.id from contributors > inner join albums > on contributors.id = albums.contributor > inner join tracks > on tracks.album = albums.id) > order by contributors.id > -------------------- > >
That spit out a list of 2642 lines. These are artists that could belong to a compilation albums, yes. '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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss