albums_artists

7 rows where artist_id = 5174

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8721 8721 8388 8388 5174 5174
14498 14498 14142 14142 5174 5174
19574 19574 19362 19362 5174 5174
23243 23243 23140 23140 5174 5174
23875 23875 23763 23763 5174 5174
25857 25857 25759 25759 5174 5174
26209 26209 26107 26107 5174 5174

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