albums_artists

5 rows where artist_id = 7389

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14187 14187 13827 13827 7389 7389
16915 16915 16605 16605 7389 7389
20911 20911 20762 20762 7389 7389
24758 24758 24641 24641 7389 7389
26239 26239 26137 26137 7389 7389

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