albums_artists

6 rows where artist_id = 4599

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7300 7300 7004 7004 4599 4599
12743 12743 12404 12404 4599 4599
20928 20928 20779 20779 4599 4599
23772 23772 23663 23663 4599 4599
24943 24943 24834 24834 4599 4599
25713 25713 25613 25613 4599 4599

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