albums_artists

9 rows where artist_id = 2486

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3103 3103 2925 2925 2486 2486
6664 6664 6373 6373 2486 2486
6665 6665 6374 6374 2486 2486
10490 10490 10151 10151 2486 2486
14309 14309 13951 13951 2486 2486
15621 15621 15283 15283 2486 2486
15622 15622 15284 15284 2486 2486
27283 27283 27117 27117 2486 2486
27639 27639 27446 27446 2486 2486

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