albums_artists

9 rows where artist_id = 1514

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1688 1688 1591 1591 1514 1514
6005 6005 5734 5734 1514 1514
9745 9745 9399 9399 1514 1514
14831 14831 14479 14479 1514 1514
18889 18889 18646 18646 1514 1514
20412 20412 20246 20246 1514 1514
21188 21188 21061 21061 1514 1514
21399 21399 21277 21277 1514 1514
22341 22341 22251 22251 1514 1514

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