albums_artists

6 rows where artist_id = 1291

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1403 1403 1320 1320 1291 1291
9866 9866 9520 9520 1291 1291
17323 17323 17021 17021 1291 1291
18829 18829 18585 18585 1291 1291
20820 20820 20668 20668 1291 1291
21314 21314 21189 21189 1291 1291

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