albums_artists

10 rows where artist_id = 1205

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1311 1311 1232 1232 1205 1205
4506 4506 4289 4289 1205 1205
5941 5941 5673 5673 1205 1205
7684 7684 7378 7378 1205 1205
8287 8287 7968 7968 1205 1205
10384 10384 10043 10043 1205 1205
12200 12200 11863 11863 1205 1205
14370 14370 14011 14011 1205 1205
16529 16529 16215 16215 1205 1205
27509 27509 27328 27328 1205 1205

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