SQL query retrieving all U2 album from the MusicBrainz database.

select_musicbrainz_u2_album

SELECT 
    release_group.gid AS albumid,
    release_group.type AS albumPrimaryTypeId,
    release_group_primary_type.name as albumPrimaryTypeName,
    release_name.name AS albumName,
    artist_name.name AS artistName,
    artist.gid AS artistGid,
    artist.type as artisTypeId,
    artist_type.name as artistTypeName,
    artist.begin_date_year artistBeginDateYear,
    gender.name as artistGender,
    area.name as artistCountryName,
    artist_meta.rating artistRating,
    artist_meta.rating_count artistRatingCount,
    release_group_meta.first_release_date_year albumYear,
    release_group_meta.rating albumRating,
    release_group_meta.rating_count albumRatingCount
FROM
    artist 
INNER JOIN artist_credit_name
    ON artist_credit_name.artist = artist.id
INNER JOIN artist_credit
    ON artist_credit.id = artist_credit_name.artist_credit
INNER JOIN release_group
    ON release_group.artist_credit = artist_credit.id
INNER JOIN release_name
    ON release_name.id = release_group.name
INNER JOIN artist_name 
   ON artist.name = artist_name.id
INNER JOIN artist_type 
   ON artist.type = artist_type.id
INNER JOIN area
   ON artist.area = area.id
INNER JOIN release_group_primary_type
    ON release_group_primary_type.id = release_group.type   
LEFT OUTER JOIN release_group_secondary_type_join
    ON release_group_secondary_type_join.release_group = release_group.id
LEFT OUTER JOIN gender
    ON artist.gender = gender.id
LEFT OUTER JOIN artist_meta
    ON artist.id = artist_meta.id    
LEFT OUTER JOIN release_group_meta
    ON release_group_meta.id = release_group.id    
WHERE
    release_group.type = '1'
    AND release_group_secondary_type_join.secondary_type IS NULL
    AND  upper(artist_name.name) = 'U2';