albums_artists

9 rows where artist_id = 109

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
114 114 112 112 109 109
1887 1887 1780 1780 109 109
4654 4654 4437 4437 109 109
7487 7487 7183 7183 109 109
8237 8237 7917 7917 109 109
9983 9983 9638 9638 109 109
12384 12384 12048 12048 109 109
12457 12457 12119 12119 109 109
13355 13355 13004 13004 109 109

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