albums_artists

9 rows where artist_id = 1109

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1201 1201 1131 1131 1109 1109
1220 1220 1150 1150 1109 1109
5803 5803 5536 5536 1109 1109
6017 6017 5746 5746 1109 1109
8872 8872 8538 8538 1109 1109
10947 10947 10606 10606 1109 1109
18560 18560 18303 18303 1109 1109
23441 23441 23336 23336 1109 1109
26884 26884 26742 26742 1109 1109

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