albums_artists

8 rows where artist_id = 3801

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5566 5566 5307 5307 3801 3801
12791 12791 12449 12449 3801 3801
14472 14472 14115 14115 3801 3801
17513 17513 17218 17218 3801 3801
19305 19305 19087 19087 3801 3801
24045 24045 23935 23935 3801 3801
24397 24397 24285 24285 3801 3801
25913 25913 25815 25815 3801 3801

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