albums_artists

8 rows where artist_id = 3533

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4990 4990 4754 4754 3533 3533
13550 13550 13198 13198 3533 3533
17117 17117 16818 16818 3533 3533
20138 20138 19961 19961 3533 3533
21404 21404 21282 21282 3533 3533
24151 24151 24042 24042 3533 3533
25649 25649 25551 25551 3533 3533
26006 26006 25907 25907 3533 3533

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