albums_artists

8 rows where artist_id = 6386

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11475 11475 11138 11138 6386 6386
14037 14037 13683 13683 6386 6386
15592 15592 15253 15253 6386 6386
17498 17498 17203 17203 6386 6386
18123 18123 17838 17838 6386 6386
18124 18124 17839 17839 6386 6386
19177 19177 18956 18956 6386 6386
21914 21914 21810 21810 6386 6386

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