albums_artists

9 rows where artist_id = 4487

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7061 7061 6764 6764 4487 4487
11554 11554 11216 11216 4487 4487
13590 13590 13239 13239 4487 4487
15859 15859 15515 15515 4487 4487
18375 18375 18101 18101 4487 4487
19953 19953 19765 19765 4487 4487
21322 21322 21197 21197 4487 4487
24034 24034 23923 23923 4487 4487
25921 25921 25823 25823 4487 4487

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