albums_artists

15 rows where artist_id = 1532

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1709 1709 1611 1611 1532 1532
9767 9767 9421 9421 1532 1532
10144 10144 9804 9804 1532 1532
10145 10145 9805 9805 1532 1532
15046 15046 14700 14700 1532 1532
15047 15047 14701 14701 1532 1532
16583 16583 16273 16273 1532 1532
19487 19487 19272 19272 1532 1532
23030 23030 22934 22934 1532 1532
23056 23056 22957 22957 1532 1532
25565 25565 25466 25466 1532 1532
25828 25828 25729 25729 1532 1532
26016 26016 25917 25917 1532 1532
26172 26172 26070 26070 1532 1532
26267 26267 26165 26165 1532 1532

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