albums_artists

9 rows where artist_id = 4083

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6146 6146 5866 5866 4083 4083
6147 6147 5867 5867 4083 4083
7372 7372 7073 7073 4083 4083
8740 8740 8407 8407 4083 4083
9263 9263 8917 8917 4083 4083
12863 12863 12520 12520 4083 4083
14476 14476 14120 14120 4083 4083
16067 16067 15740 15740 4083 4083
17553 17553 17259 17259 4083 4083

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