albums_artists

8 rows where artist_id = 1954

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2276 2276 2133 2133 1954 1954
7332 7332 7035 7035 1954 1954
21142 21142 21013 21013 1954 1954
22541 22541 22447 22447 1954 1954
24013 24013 23902 23902 1954 1954
24207 24207 24096 24096 1954 1954
25729 25729 25629 25629 1954 1954
25947 25947 25848 25848 1954 1954

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