albums_artists

9 rows where artist_id = 1684

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1907 1907 1799 1799 1684 1684
6826 6826 6529 6529 1684 1684
7989 7989 7677 7677 1684 1684
8714 8714 8382 8382 1684 1684
9555 9555 9210 9210 1684 1684
14590 14590 14236 14236 1684 1684
18307 18307 18030 18030 1684 1684
19833 19833 19639 19639 1684 1684
22260 22260 22169 22169 1684 1684

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