albums_artists

12 rows where artist_id = 2991

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3965 3965 3761 3761 2991 2991
7154 7154 6854 6854 2991 2991
11507 11507 11170 11170 2991 2991
12714 12714 12375 12375 2991 2991
12928 12928 12585 12585 2991 2991
16414 16414 16100 16100 2991 2991
18321 18321 18046 18046 2991 2991
18626 18626 18375 18375 2991 2991
20723 20723 20563 20563 2991 2991
21180 21180 21053 21053 2991 2991
21674 21674 21563 21563 2991 2991
23867 23867 23755 23755 2991 2991

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