albums_artists

13 rows where artist_id = 520

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
535 535 513 513 520 520
5041 5041 4802 4802 520 520
7229 7229 6931 6931 520 520
9963 9963 9618 9618 520 520
12757 12757 12416 12416 520 520
13671 13671 13320 13320 520 520
14686 14686 14331 14331 520 520
16130 16130 15803 15803 520 520
18542 18542 18283 18283 520 520
20040 20040 19857 19857 520 520
20826 20826 20674 20674 520 520
20827 20827 20675 20675 520 520
20828 20828 20676 20676 520 520

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