I want to extract all recordings of several specific artist. For that I loaded the musicbrainz database on a local postgresql instance using mbdata (https://github.com/lalinsky/mbdata).
I tried the following command but it did not work :
select artist.name, recording.name from recording, l_artist_recording, artist where recording.id=l_artist_recording.entity1 AND artist.id=l_artist_recording.entity0 and artist.name=‘Nekfeu’;
Indeed, I noticed that the number of rows in the table recordings is different than in l_artist_recording. So this mean that we do not have the information of the artist for all recordings right ?
Do someone know why this is the case ? Or maybe I did not understand correctly the database schema ? Do you know how I can answer my question ?