albums_artists

14 rows where artist_id = 1069

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1135 1135 1070 1070 1069 1069
4459 4459 4245 4245 1069 1069
6098 6098 5820 5820 1069 1069
6768 6768 6474 6474 1069 1069
7350 7350 7052 7052 1069 1069
8773 8773 8441 8441 1069 1069
9236 9236 8891 8891 1069 1069
9594 9594 9248 9248 1069 1069
9829 9829 9482 9482 1069 1069
10004 10004 9658 9658 1069 1069
10073 10073 9730 9730 1069 1069
10075 10075 9731 9731 1069 1069
12468 12468 12131 12131 1069 1069
13362 13362 13011 13011 1069 1069

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