albums_artists

5 rows where artist_id = 3863

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5675 5675 5411 5411 3863 3863
10318 10318 9974 9974 3863 3863
11937 11937 11594 11594 3863 3863
13178 13178 12838 12838 3863 3863
26493 26493 26383 26383 3863 3863

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