albums_artists

13 rows where artist_id = 4680

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7514 7514 7209 7209 4680 4680
7909 7909 7593 7593 4680 4680
9523 9523 9178 9178 4680 4680
10824 10824 10486 10486 4680 4680
11287 11287 10950 10950 4680 4680
12094 12094 11753 11753 4680 4680
12813 12813 12471 12471 4680 4680
13803 13803 13448 13448 4680 4680
14352 14352 13993 13993 4680 4680
15665 15665 15327 15327 4680 4680
16239 16239 15918 15918 4680 4680
16909 16909 16599 16599 4680 4680
18092 18092 17807 17807 4680 4680

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