albums_artists

25 rows where artist_id = 858

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
897 897 850 850 858 858
4137 4137 3936 3936 858 858
4262 4262 4059 4059 858 858
4263 4263 4060 4060 858 858
4264 4264 4061 4061 858 858
4265 4265 4062 4062 858 858
4266 4266 4063 4063 858 858
7886 7886 7569 7569 858 858
9662 9662 9316 9316 858 858
14773 14773 14418 14418 858 858
16784 16784 16476 16476 858 858
17777 17777 17485 17485 858 858
19182 19182 18961 18961 858 858
19774 19774 19578 19578 858 858
20357 20357 20189 20189 858 858
20905 20905 20756 20756 858 858
21166 21166 21039 21039 858 858
22843 22843 22748 22748 858 858
24020 24020 23909 23909 858 858
24067 24067 23957 23957 858 858
24887 24887 24776 24776 858 858
26076 26076 25973 25973 858 858
26161 26161 26059 26059 858 858
27045 27045 26895 26895 858 858
27526 27526 27341 27341 858 858

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