albums_artists

11 rows where artist_id = 2880

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3767 3767 3568 3568 2880 2880
5021 5021 4782 4782 2880 2880
6392 6392 6102 6102 2880 2880
8204 8204 7884 7884 2880 2880
8664 8664 8329 8329 2880 2880
9485 9485 9138 9138 2880 2880
9998 9998 9654 9654 2880 2880
10943 10943 10602 10602 2880 2880
11729 11729 11387 11387 2880 2880
12252 12252 11915 11915 2880 2880
27489 27489 27312 27312 2880 2880

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