albums_artists

10 rows where artist_id = 3117

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4193 4193 3991 3991 3117 3117
10373 10373 10032 10032 3117 3117
13575 13575 13224 13224 3117 3117
14821 14821 14468 14468 3117 3117
15084 15084 14739 14739 3117 3117
18355 18355 18080 18080 3117 3117
19457 19457 19240 19240 3117 3117
21122 21122 20990 20990 3117 3117
21123 21123 20991 20991 3117 3117
21679 21679 21568 21568 3117 3117

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