albums_artists

8 rows where artist_id = 1529

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1706 1706 1608 1608 1529 1529
4225 4225 4023 4023 1529 1529
4816 4816 4597 4597 1529 1529
6642 6642 6351 6351 1529 1529
9651 9651 9305 9305 1529 1529
12143 12143 11804 11804 1529 1529
14477 14477 14121 14121 1529 1529
26671 26671 26550 26550 1529 1529

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