albums_artists

5 rows where artist_id = 6084

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10797 10797 10460 10460 6084 6084
15477 15477 15136 15136 6084 6084
18325 18325 18050 18050 6084 6084
20109 20109 19931 19931 6084 6084
23344 23344 23240 23240 6084 6084

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