albums_artists

5 rows where artist_id = 5991

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10597 10597 10259 10259 5991 5991
15152 15152 14806 14806 5991 5991
15943 15943 15606 15606 5991 5991
16454 16454 16141 16141 5991 5991
19490 19490 19275 19275 5991 5991

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