albums_artists

19 rows where artist_id = 2226

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2694 2694 2533 2533 2226 2226
3447 3447 3253 3253 2226 2226
3538 3538 3341 3341 2226 2226
4759 4759 4543 4543 2226 2226
5252 5252 5008 5008 2226 2226
5513 5513 5257 5257 2226 2226
7234 7234 6937 6937 2226 2226
8084 8084 7770 7770 2226 2226
9110 9110 8769 8769 2226 2226
9544 9544 9199 9199 2226 2226
9798 9798 9450 9450 2226 2226
16440 16440 16126 16126 2226 2226
17147 17147 16850 16850 2226 2226
19181 19181 18959 18959 2226 2226
21492 21492 21373 21373 2226 2226
25289 25289 25187 25187 2226 2226
25424 25424 25325 25325 2226 2226
25428 25428 25328 25328 2226 2226
26989 26989 26842 26842 2226 2226

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