albums_artists

5 rows where artist_id = 3857

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5657 5657 5394 5394 3857 3857
6268 6268 5982 5982 3857 3857
13009 13009 12667 12667 3857 3857
14267 14267 13911 13911 3857 3857
18229 18229 17950 17950 3857 3857

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