albums_artists

9 rows where artist_id = 879

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
919 919 870 870 879 879
2995 2995 2823 2823 879 879
3835 3835 3634 3634 879 879
6069 6069 5794 5794 879 879
7072 7072 6774 6774 879 879
8487 8487 8157 8157 879 879
10012 10012 9667 9667 879 879
12054 12054 11713 11713 879 879
12516 12516 12177 12177 879 879

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