albums_artists

7 rows where artist_id = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
76 76 74 74 71 71
5926 5926 5658 5658 71 71
11544 11544 11206 11206 71 71
13983 13983 13628 13628 71 71
15791 15791 15452 15452 71 71
18743 18743 18500 18500 71 71
27539 27539 27353 27353 71 71

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