albums_artists

12 rows where artist_id = 1158

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1260 1260 1183 1183 1158 1158
2381 2381 2232 2232 1158 1158
6555 6555 6266 6266 1158 1158
8315 8315 7994 7994 1158 1158
8788 8788 8455 8455 1158 1158
13033 13033 12693 12693 1158 1158
18934 18934 18697 18697 1158 1158
19544 19544 19331 19331 1158 1158
22000 22000 21900 21900 1158 1158
23494 23494 23388 23388 1158 1158
25299 25299 25200 25200 1158 1158
27323 27323 27155 27155 1158 1158

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