albums_artists

13 rows where artist_id = 3877

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5701 5701 5438 5438 3877 3877
10929 10929 10588 10588 3877 3877
14760 14760 14406 14406 3877 3877
15956 15956 15617 15617 3877 3877
17520 17520 17225 17225 3877 3877
18391 18391 18120 18120 3877 3877
19550 19550 19337 19337 3877 3877
19862 19862 19669 19669 3877 3877
20283 20283 20109 20109 3877 3877
20407 20407 20241 20241 3877 3877
21392 21392 21270 21270 3877 3877
24543 24543 24423 24423 3877 3877
25906 25906 25809 25809 3877 3877

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)
);