> New:
>
> SELECT contributors.id, contributors.name, contributors.namesort,
> contributors.musicmagic_mixable
> FROM contributors
> JOIN contributor_track ON contributor_track.contributor =
> contributors.id
> JOIN tracks ON tracks.id = contributor_track.track
> JOIN genre_track ON genre_track.track = tracks.id
> JOIN albums ON albums.id = tracks.album
> WHERE genre_track.genre = $genre_id AND contributor_track.role IN (1,5)
> AND (albums.compilation IS NULL OR albums.compilation = 0)
> GROUP BY contributors.id
> ORDER BY contributors.namesort
>
Is "contributor_track.role IN (1,5)" a fixed part of the query, or is this
dynamically built according to the user preferences in My Music for Conductor,
Composer, Band/Orchestra? i.e. the query at the moment only returns Artist and
Album Artist roles, but should include other roles if requested.
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
