albums_artists

9 rows where artist_id = 4398

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6870 6870 6571 6571 4398 4398
7520 7520 7215 7215 4398 4398
12632 12632 12294 12294 4398 4398
15488 15488 15145 15145 4398 4398
19867 19867 19674 19674 4398 4398
22104 22104 22007 22007 4398 4398
22105 22105 22008 22008 4398 4398
23416 23416 23312 23312 4398 4398
23852 23852 23740 23740 4398 4398

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