albums_artists

6 rows where artist_id = 4420

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6919 6919 6620 6620 4420 4420
11610 11610 11273 11273 4420 4420
14318 14318 13961 13961 4420 4420
14988 14988 14639 14639 4420 4420
15519 15519 15178 15178 4420 4420
27313 27313 27145 27145 4420 4420

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