albums_artists

6 rows where artist_id = 765

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
795 795 755 755 765 765
5896 5896 5629 5629 765 765
9413 9413 9065 9065 765 765
10686 10686 10352 10352 765 765
11388 11388 11049 11049 765 765
18348 18348 18073 18073 765 765

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