albums_artists

10 rows where artist_id = 709

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
735 735 702 702 709 709
8697 8697 8364 8364 709 709
11681 11681 11342 11342 709 709
12895 12895 12552 12552 709 709
16866 16866 16556 16556 709 709
17732 17732 17436 17436 709 709
19630 19630 19425 19425 709 709
21328 21328 21203 21203 709 709
22037 22037 21937 21937 709 709
22446 22446 22350 22350 709 709

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