albums_artists

14 rows where artist_id = 5836

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10241 10241 9902 9902 5836 5836
11311 11311 10974 10974 5836 5836
15059 15059 14714 14714 5836 5836
15975 15975 15636 15636 5836 5836
16320 16320 16006 16006 5836 5836
18255 18255 17977 17977 5836 5836
18506 18506 18243 18243 5836 5836
18507 18507 18244 18244 5836 5836
19057 19057 18830 18830 5836 5836
20171 20171 19994 19994 5836 5836
20854 20854 20701 20701 5836 5836
21258 21258 21134 21134 5836 5836
21719 21719 21610 21610 5836 5836
22200 22200 22107 22107 5836 5836

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