albums_artists

8 rows where artist_id = 81

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
86 86 83 83 81 81
2414 2414 2263 2263 81 81
9118 9118 8775 8775 81 81
19496 19496 19281 19281 81 81
23776 23776 23667 23667 81 81
24042 24042 23932 23932 81 81
26005 26005 25906 25906 81 81
26402 26402 26296 26296 81 81

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