albums_artists

9 rows where artist_id = 3394

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4677 4677 4461 4461 3394 3394
4678 4678 4462 4462 3394 3394
4679 4679 4463 4463 3394 3394
4680 4680 4464 4464 3394 3394
7482 7482 7178 7178 3394 3394
8153 8153 7834 7834 3394 3394
13810 13810 13454 13454 3394 3394
14448 14448 14091 14091 3394 3394
21076 21076 20938 20938 3394 3394

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);