albums_artists

10 rows where artist_id = 3868

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5684 5684 5421 5421 3868 3868
15279 15279 14934 14934 3868 3868
16070 16070 15743 15743 3868 3868
16789 16789 16481 16481 3868 3868
18517 18517 18255 18255 3868 3868
18518 18518 18256 18256 3868 3868
20750 20750 20592 20592 3868 3868
21757 21757 21649 21649 3868 3868
23996 23996 23884 23884 3868 3868
24981 24981 24873 24873 3868 3868

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