albums_artists

13 rows where artist_id = 218

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
224 224 215 215 218 218
3815 3815 3613 3613 218 218
5968 5968 5698 5698 218 218
6814 6814 6517 6517 218 218
9877 9877 9531 9531 218 218
10021 10021 9676 9676 218 218
14946 14946 14595 14595 218 218
15796 15796 15457 15457 218 218
16374 16374 16060 16060 218 218
17344 17344 17042 17042 218 218
18591 18591 18339 18339 218 218
19758 19758 19562 19562 218 218
20638 20638 20475 20475 218 218

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