albums_artists

9 rows where artist_id = 1217

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1323 1323 1244 1244 1217 1217
5620 5620 5359 5359 1217 1217
10166 10166 9826 9826 1217 1217
12351 12351 12015 12015 1217 1217
13356 13356 13005 13005 1217 1217
14561 14561 14207 14207 1217 1217
14562 14562 14208 14208 1217 1217
16080 16080 15753 15753 1217 1217
17735 17735 17439 17439 1217 1217

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