erland;639210 Wrote: > I would like to change change this query to something like this, but it > requires that the scanner adds the necessary album artist entries to > contributor_album. > > Code: -------------------- > > > SELECT contributors.* FROM contributors > JOIN contributor_album ON contributor_album.contributor = contributors.id > WHERE > contributor_album.role IN (5) > GROUP BY contributors.id > ORDER BY contributors.namesort > -------------------- > > >
That's one of the reasons that for years I've been saying that the scanner should always assign a role of album artist for every album, whether it comes from an explicit ALBUMARTIST tag or just from the ARTIST tags. It would greatly simplify a number of queries. > > The more I think about this I'd really like separate menus for: > - All Artists > - Album Artists > - Composers > - Conductors > - Compilations > - Albums > So would I. Again, with the recent onebrowser work, this should be fairly trivial, since little, if any, special handling needs to be done for the different interfaces now. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=88072 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/ripping
