albums_artists

9 rows where artist_id = 938

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
982 982 926 926 938 938
3120 3120 2942 2942 938 938
7104 7104 6805 6805 938 938
11987 11987 11645 11645 938 938
19401 19401 19185 19185 938 938
21031 21031 20889 20889 938 938
21863 21863 21759 21759 938 938
24142 24142 24034 24034 938 938
24458 24458 24346 24346 938 938

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