Philip Meyer;600494 Wrote:
> >You are right, I missed the albums.contributor column, I was just
> >looking at the roles in the contributor_track and contributor_album
> >tables. Now the current database contents makes a bit more sense.
> >
> There is a difference/something to bear in mind.
>
> Obviously album.contributor can only have one artist. However, it is
> possible for an album to have more than one album artist.
>
> eg. an album by Jimmy Page and Robert Plant, where there is one guest
> performer on one song. Therefore most songs would have Album Artist =
> Jimmy Page; Album Artist=Robert Plant.
>
I think multiple album artists should be represented as a band/group,
in this case "Jimmy Page & Robert Plant" instead of two individual
artists. If you want to represent them as individual artists you get
into problem when you want to sort the "Albums" menu by artist, should
this be sorted by "Jimmy Page" or by "Robert Plant" ?
How is this handled with the current SBS ? Does it even support
multiple ALBUMARTIST tags ?
Philip Meyer;600494 Wrote:
>
> So the only safe way to capture a list of all album artists, is to use
> album artist contributor roles link table.
>
The current database model also makes it a bit complicated to get album
artists from contributor_album because you need to get:
- All artists which have role = "Album Artist". Basically include
ALBUMARTIST tags.
Plus
- All artists which ave a role "Artist" but is on an album which
doesn't have any artist with an "album artist" role. Basically include
ARTIST tags for normal albums.
The artists with an artist role which only exists on albums where there
is an album artist shouldn't be displayed, if we want to mimic the
current menu.
It's certainly possible to do this in SQL but it gets more complex
since you have to handle the exclusions as described in point 2 above.
That's why I suggested the database change but even after the database
change the sorting problem would remain.
Still, I'm wondering if these special cases should be represented as a
band/group instead of two individual artists, that will also solve the
sorting problem.
--
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=84475
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
