albums_artists

9 rows where artist_id = 8051

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16074 16074 15747 15747 8051 8051
17684 17684 17389 17389 8051 8051
19937 19937 19749 19749 8051 8051
20368 20368 20200 20200 8051 8051
21336 21336 21211 21211 8051 8051
23485 23485 23379 23379 8051 8051
24084 24084 23974 23974 8051 8051
25710 25710 25610 25610 8051 8051
25962 25962 25863 25863 8051 8051

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