albums_artists

14 rows where artist_id = 2823

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3676 3676 3478 3478 2823 2823
4319 4319 4115 4115 2823 2823
8828 8828 8497 8497 2823 2823
11109 11109 10771 10771 2823 2823
13729 13729 13375 13375 2823 2823
13731 13731 13376 13376 2823 2823
16814 16814 16506 16506 2823 2823
17415 17415 17121 17121 2823 2823
18971 18971 18736 18736 2823 2823
20960 20960 20815 20815 2823 2823
21694 21694 21583 21583 2823 2823
22680 22680 22587 22587 2823 2823
23880 23880 23768 23768 2823 2823
25192 25192 25087 25087 2823 2823

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