albums_artists

7 rows where artist_id = 1701

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1930 1930 1819 1819 1701 1701
3606 3606 3411 3411 1701 1701
8354 8354 8030 8030 1701 1701
10081 10081 9737 9737 1701 1701
12645 12645 12306 12306 1701 1701
13906 13906 13547 13547 1701 1701
14446 14446 14089 14089 1701 1701

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