albums_artists

4 rows where artist_id = 9916

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21346 21346 21223 21223 9916 9916
23328 23328 23224 23224 9916 9916
24123 24123 24013 24013 9916 9916
25089 25089 24986 24986 9916 9916

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