albums_artists

8 rows where artist_id = 5072

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8477 8477 8148 8148 5072 5072
12086 12086 11746 11746 5072 5072
15291 15291 14947 14947 5072 5072
17035 17035 16733 16733 5072 5072
19028 19028 18798 18798 5072 5072
20143 20143 19966 19966 5072 5072
22782 22782 22692 22692 5072 5072
24315 24315 24203 24203 5072 5072

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