albums_artists

9 rows where artist_id = 4217

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6506 6506 6215 6215 4217 4217
11924 11924 11581 11581 4217 4217
14715 14715 14361 14361 4217 4217
15377 15377 15034 15034 4217 4217
19192 19192 18971 18971 4217 4217
21041 21041 20900 20900 4217 4217
21911 21911 21807 21807 4217 4217
24696 24696 24574 24574 4217 4217
26895 26895 26753 26753 4217 4217

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