Hey, I’m a newbie and may not understand how your thourough/incredible database works. I’m having trouble trying to match artist and relase for a small but significant percentage of cases.
One example : the artist So Hideous (artist.id=1309810) has released an album called “Laurestine” (release.id=1705132) in Prosthetic Records (label_id=881). Nevertheless, when I look at the release table, the release “Laurestine” is linked to another artist (release.artist_credit=1583880, corresponding to artist Tempos de Morte). I must have made some mistake matching the tables, but what is my mystake ?
Cheers !
1 Like
artist_credit
is a different table. I believe that you can join release.artist_credit
to artist_credit_name.artist_credit
and then join artist_credit_name.artist
to artist.id
. See Artist_credit and artist_credit_name in database schema for more details.
1 Like
Thanks for the info, derat!