vagskal;639199 Wrote:
> On 7.5.4 an album with ALBUMARTIST=Nils Ferlin [The name of a
> composer/poet who is not album artist or artist on any album] and
> COMPILATION=1 will not generate a Nils Ferlin entry in the artist list
> (when composers are not set to appear in that list).
>
Actually it's even worse than that, I just tried.
My "Various Artists" entry under "V" disappears if I add COMPILATION=1
tags to my Album1.
If you have selected "Group compilation albums together" you will ONLY
see artists in the "Artists" menu which is part of at least one non
compilation album.
Which means that for most users, which have ALBUMARTIST="Various
Artists" and don't have COMPILATION=1, the result is that the "Various
Artists" entry under "V" is never going to appear. So it means that
these useres won't be able to reach the compilations albums through the
"Artists" menu if they've selected "Group compilation albums together"
option.
To be able to handle this, we need to get rid of the filtering using
"(albums.compilation is null or albums.compilation=0)" but to be able
to do that it gets even more important that both Album3, Album4 AND
Album5 gets an album artist in contributor_album table.
For reference, the artists query when "Group compilation albums
together" is enabled and you have selected to show composers looks like
this:
Code:
--------------------
SELECT contributors.* FROM contributors
JOIN contributor_album ON contributor_album.contributor = contributors.id
JOIN albums ON contributor_album.album = albums.id
WHERE
contributor_album.role IN (1,2,5) AND
(albums.compilation IS NULL OR albums.compilation = 0)
GROUP BY contributors.id
ORDER BY contributors.namesort
--------------------
So it will not include an artist unless it exists on at least one non
compilation album.
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
--------------------
But this is where it gets complicated since we don't have any separate
Composer and Conductor menus, so we will probably end up with:
Code:
--------------------
SELECT contributors.* FROM contributors
JOIN contributor_album ON contributor_album.contributor = contributors.id
WHERE
contributor_album.role IN (2,5)
GROUP BY contributors.id
ORDER BY contributors.namesort
--------------------
Which means you will see composers which only is available on
compilation albums in the list and I'm not sure that's desirable as I
think some tagging software tends to add also COMPOSER tags on most
tracks.
The more I think about this I'd really like separate menus for:
- All Artists
- Album Artists
- Composers
- Conductors
- Compilations
- Albums
But then we are back to how to handle the "Genres" menu again.
If "Genres" only contains "Album Artists" it wouldn't be possible to
browse to "Genres/Classical/Beethoven" unless you've tagged it with
ALBUMARTIST="Beethoven" which is probably not desirable on a "Hillary
Hahn" album.
If "Genres" contains also composer and conductors, you might end up
with a long list of composers from compilation Pop/Rock albums under
the "Genres" menu.
But maybe all this is to take this discussion a bit out of scope, we
should probably not solve the limitations of classical and jazz music
browsing in this thread. I really think we need deeper menu hierarchies
to solve the classical/jazz browsing problem.
Now I'm starting to think that it's best to keep the new "Compilations"
menu I suggested inside the "Artists" menu and just rename it from
"Various Artists" to "Compilations" to avoid the collision.
This "Group compilation albums together" setting really gives me
headache.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=88072
_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/ripping
