albums_artists

11 rows where artist_id = 3817

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5595 5595 5336 5336 3817 3817
8599 8599 8265 8265 3817 3817
9115 9115 8772 8772 3817 3817
21825 21825 21722 21722 3817 3817
22042 22042 21943 21943 3817 3817
22606 22606 22513 22513 3817 3817
22607 22607 22514 22514 3817 3817
23027 23027 22931 22931 3817 3817
24171 24171 24062 24062 3817 3817
24172 24172 24063 24063 3817 3817
24391 24391 24279 24279 3817 3817

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