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