albums_artists

9 rows where artist_id = 2882

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3770 3770 3570 3570 2882 2882
7024 7024 6725 6725 2882 2882
10417 10417 10076 10076 2882 2882
15697 15697 15360 15360 2882 2882
18962 18962 18727 18727 2882 2882
21363 21363 21240 21240 2882 2882
24048 24048 23938 23938 2882 2882
25764 25764 25665 25665 2882 2882
26672 26672 26551 26551 2882 2882

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