albums_artists

9 rows where artist_id = 3950

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5864 5864 5597 5597 3950 3950
8447 8447 8120 8120 3950 3950
10169 10169 9829 9829 3950 3950
11414 11414 11075 11075 3950 3950
13895 13895 13537 13537 3950 3950
15265 15265 14920 14920 3950 3950
17405 17405 17111 17111 3950 3950
18047 18047 17756 17756 3950 3950
26985 26985 26837 26837 3950 3950

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