albums_artists

6 rows where artist_id = 8154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16331 16331 16017 16017 8154 8154
17438 17438 17144 17144 8154 8154
18143 18143 17859 17859 8154 8154
19069 19069 18844 18844 8154 8154
20438 20438 20272 20272 8154 8154
24167 24167 24058 24058 8154 8154

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