albums_artists

6 rows where artist_id = 9105

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18924 18924 18684 18684 9105 9105
21051 21051 20910 20910 9105 9105
25186 25186 25081 25081 9105 9105
26117 26117 26014 26014 9105 9105
26121 26121 26018 26018 9105 9105
26206 26206 26104 26104 9105 9105

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