albums_artists

6 rows where artist_id = 1145

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1247 1247 1172 1172 1145 1145
5574 5574 5315 5315 1145 1145
7841 7841 7527 7527 1145 1145
9786 9786 9439 9439 1145 1145
10127 10127 9787 9787 1145 1145
11906 11906 11563 11563 1145 1145

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