albums_artists

7 rows where artist_id = 915

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
957 957 902 902 915 915
8147 8147 7828 7828 915 915
11075 11075 10735 10735 915 915
12788 12788 12446 12446 915 915
15653 15653 15315 15315 915 915
18798 18798 18555 18555 915 915
20665 20665 20503 20503 915 915

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