albums_artists

10 rows where artist_id = 3995

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5945 5945 5677 5677 3995 3995
7474 7474 7171 7171 3995 3995
7715 7715 7408 7408 3995 3995
7716 7716 7409 7409 3995 3995
7717 7717 7410 7410 3995 3995
7718 7718 7411 7411 3995 3995
8232 8232 7912 7912 3995 3995
10264 10264 9923 9923 3995 3995
17797 17797 17505 17505 3995 3995
20923 20923 20774 20774 3995 3995

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