I am trying to get sql query for getting an artist’s studio and live albums. The artist id is “0ab49580-c84f-44d4-875f-d83760ea2cfe” (Maroon 5). I do not wants demos or any other types. In essence I want to extract just the “Album” and “Album + Live” sections of https://musicbrainz.org/artist/0ab49580-c84f-44d4-875f-d83760ea2cfe
I believe I have found the right code here: https://github.com/metabrainz/musicbrainz-server/blob/62dee4ae7ca65b306b7aeef618037ad4bfcc380c/lib/MusicBrainz/Server/Data/ReleaseGroup.pm#L144-L169
If I pass in Maroon 5’s artist id of 66179 (eg “WHERE rg.artist_credit=66179”) I get all of their albums (I think). But how do I then determine if it is studio album, live, demo, EP, single, etc? Maybe I have the incorrect sql code. It has been quite sometime from whence I have read perl.