[My mailreader confirms I replied to this, but I have not seen it come through on the beta list..]
>>>>> Triode <[EMAIL PROTECTED]> writes: > Greg, the latest version should sort by the album contributor. What is > this set to for your compilation albums? You've hit upon my problem: for the albums that have different artists on different tracks, the album contributor is randomly set to one of the track artists. > If you enable --d_sql you can see the database query being done. For > sort by artist it is now essentially: > SELECT * FROM albums, contributors WHERE albums.contibutors = > contributor.id ORDER BY contributors.namesort; I wonder if I should add a bit of code to mergeVariousArtistsAlbums so that when it sets the compilation bit, it also sets the contributor to "Various Artists"? It is interesting that I do not have any problems with Browse Artists. I turned on d_sql and for Browse Artists it's doing: SELECT DISTINCT contributors.id AS id,contributors.name AS name,contributors.namesort AS namesort,contributors.moodlogic_id AS moodlogic_id,contributors.moodlogic_mixable AS moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM contributor_track, tracks, contributors, albums WHERE contributor_track.track = tracks.id AND contributors.id = contributor_track.contributor AND albums.id = tracks.album AND ( albums.compilation = ? AND contributor_track.role IN ( ?, ? ) ) ORDER BY contributors.namesort whereas for Browse Artwork it's doing: SELECT DISTINCT albums.id AS id,albums.title AS title,albums.titlesort AS titlesort,albums.contributor AS contributor,albums.compilation AS compilation,albums.year AS year,albums.artwork AS artwork,albums.disc AS disc,albums.discc AS discc,albums.musicmagic_mixable AS musicmagic_mixable FROM tracks, contributors, albums WHERE albums.id = tracks.album AND ( contributors.id = albums.contributor ) ORDER BY contributors.namesort, tracks.year, albums.titlesort, albums.disc Maybe you can see what the relevant difference is? greg _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
