SELECT * FROM artists left join albums on (albums.idartist=artists.id) WHERE artist_url='awesome-snakes'