6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '5' ) ) AND ( me.album = '1' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '4' ) ) AND ( me.album = '1' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '1' ) ) AND ( me.album = '1' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '5' ) ) AND ( me.album = '3' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '4' ) ) AND ( me.album = '3' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '1' ) ) AND ( me.album = '3' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '5' ) ) AND ( me.album = '2' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '4' ) ) AND ( me.album = '2' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '1' ) ) AND ( me.album = '2' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '5' ) ) AND ( me.album = '708' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '4' ) ) AND ( me.album = '708' ) ) ) GROUP BY contributor.id ORDER BY role desc 6 Query SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( '1' ) ) AND ( me.album = '708' ) ) ) GROUP BY contributor.id ORDER BY role desc