albums_artists

11 rows where artist_id = 188

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
193 193 186 186 188 188
1145 1145 1079 1079 188 188
2617 2617 2464 2464 188 188
4140 4140 3939 3939 188 188
4766 4766 4549 4549 188 188
11162 11162 10823 10823 188 188
11539 11539 11201 11201 188 188
14578 14578 14224 14224 188 188
15768 15768 15431 15431 188 188
16969 16969 16661 16661 188 188
19348 19348 19130 19130 188 188

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