albums_artists

8 rows where artist_id = 890

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
930 930 879 879 890 890
3934 3934 3733 3733 890 890
4878 4878 4652 4652 890 890
13417 13417 13066 13066 890 890
14774 14774 14419 14419 890 890
15871 15871 15527 15527 890 890
19885 19885 19696 19696 890 890
20443 20443 20277 20277 890 890

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