albums_artists

13 rows where artist_id = 220

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
226 226 217 217 220 220
4938 4938 4705 4705 220 220
6667 6667 6376 6376 220 220
6668 6668 6377 6377 220 220
6669 6669 6378 6378 220 220
7449 7449 7149 7149 220 220
7451 7451 7150 7150 220 220
7453 7453 7151 7151 220 220
12750 12750 12411 12411 220 220
19336 19336 19119 19119 220 220
19621 19621 19415 19415 220 220
25507 25507 25406 25406 220 220
26532 26532 26421 26421 220 220

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