albums_artists

4 rows where artist_id = 3808

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5583 5583 5324 5324 3808 3808
7900 7900 7583 7583 3808 3808
9984 9984 9639 9639 3808 3808
26698 26698 26570 26570 3808 3808

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