What's the condition for matching items in this LEFT JOIN query?
LEFT JOIN
album.artist_id = artist.id
LEFT JOIN artist
album.artist_id = artist.id.