albums_artists

10 rows where artist_id = 1943

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2256 2256 2117 2117 1943 1943
6152 6152 5873 5873 1943 1943
9550 9550 9205 9205 1943 1943
12264 12264 11927 11927 1943 1943
12479 12479 12141 12141 1943 1943
13877 13877 13520 13520 1943 1943
14229 14229 13869 13869 1943 1943
17420 17420 17126 17126 1943 1943
19786 19786 19591 19591 1943 1943
21016 21016 20873 20873 1943 1943

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