albums_artists

6 rows where artist_id = 7863

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15561 15561 15219 15219 7863 7863
19826 19826 19631 19631 7863 7863
21604 21604 21490 21490 7863 7863
22063 22063 21966 21966 7863 7863
23866 23866 23754 23754 7863 7863
25682 25682 25582 25582 7863 7863

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