albums_artists

5 rows where artist_id = 786

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
818 818 776 776 786 786
10870 10870 10532 10532 786 786
15000 15000 14652 14652 786 786
17934 17934 17642 17642 786 786
20248 20248 20073 20073 786 786

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