albums_artists

10 rows where artist_id = 4151

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6318 6318 6032 6032 4151 4151
10228 10228 9889 9889 4151 4151
12842 12842 12499 12499 4151 4151
15537 15537 15196 15196 4151 4151
17680 17680 17385 17385 4151 4151
18986 18986 18753 18753 4151 4151
19260 19260 19041 19041 4151 4151
22703 22703 22611 22611 4151 4151
23735 23735 23626 23626 4151 4151
25799 25799 25700 25700 4151 4151

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