With every album having an album artist(s), it also makes it very simple
to implement 'Browse Album Artists'.
Code:
--------------------
-- Generate list of album artists
SELECT DISTINCT ca.contributor,
CAST(c.name AS CHAR) AS album_artist
FROM contributor_album ca
INNER JOIN contributors c ON c.id = ca.contributor
WHERE ca.role = 5
ORDER BY c.namesort;
--------------------
If you want to have the VA artist bubble to the top, as it's done now
in Browse Artists, all you need to do is manipulate its namesort column
in the contributors table.
--
JJZolx
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=94357
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
