albums_artists

11 rows where artist_id = 6038

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10697 10697 10361 10361 6038 6038
16323 16323 16009 16009 6038 6038
21243 21243 21118 21118 6038 6038
23137 23137 23036 23036 6038 6038
23138 23138 23037 23037 6038 6038
23139 23139 23038 23038 6038 6038
23140 23140 23039 23039 6038 6038
23141 23141 23040 23040 6038 6038
25134 25134 25028 25028 6038 6038
25708 25708 25608 25608 6038 6038
26305 26305 26203 26203 6038 6038

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