albums_artists

9 rows where artist_id = 3775

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5501 5501 5245 5245 3775 3775
7003 7003 6704 6704 3775 3775
12365 12365 12029 12029 3775 3775
13683 13683 13331 13331 3775 3775
14691 14691 14336 14336 3775 3775
15532 15532 15191 15191 3775 3775
15797 15797 15457 15457 3775 3775
16446 16446 16132 16132 3775 3775
23258 23258 23156 23156 3775 3775

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