albums_artists

5 rows where artist_id = 5921

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10463 10463 10121 10121 5921 5921
13386 13386 13036 13036 5921 5921
15231 15231 14886 14886 5921 5921
16259 16259 15938 15938 5921 5921
18630 18630 18379 18379 5921 5921

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