albums_artists

11 rows where artist_id = 3805

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5572 5572 5313 5313 3805 3805
7427 7427 7128 7128 3805 3805
10348 10348 10006 10006 3805 3805
12077 12077 11736 11736 3805 3805
13200 13200 12858 12858 3805 3805
14984 14984 14634 14634 3805 3805
15129 15129 14784 14784 3805 3805
16493 16493 16179 16179 3805 3805
17659 17659 17364 17364 3805 3805
17787 17787 17495 17495 3805 3805
19153 19153 18931 18931 3805 3805

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