albums_artists

17 rows where artist_id = 2216

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2674 2674 2514 2514 2216 2216
11265 11265 10929 10929 2216 2216
13294 13294 12948 12948 2216 2216
13295 13295 12949 12949 2216 2216
14797 14797 14443 14443 2216 2216
15864 15864 15520 15520 2216 2216
19413 19413 19197 19197 2216 2216
19530 19530 19317 19317 2216 2216
19933 19933 19745 19745 2216 2216
21058 21058 20919 20919 2216 2216
22116 22116 22019 22019 2216 2216
22117 22117 22020 22020 2216 2216
24746 24746 24627 24627 2216 2216
24769 24769 24653 24653 2216 2216
24977 24977 24869 24869 2216 2216
26033 26033 25934 25934 2216 2216
26204 26204 26102 26102 2216 2216

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