albums_artists

15 rows where artist_id = 5564

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9616 9616 9270 9270 5564 5564
12880 12880 12537 12537 5564 5564
12967 12967 12624 12624 5564 5564
12968 12968 12625 12625 5564 5564
12969 12969 12626 12626 5564 5564
12970 12970 12627 12627 5564 5564
12971 12971 12628 12628 5564 5564
12972 12972 12629 12629 5564 5564
12973 12973 12630 12630 5564 5564
12974 12974 12631 12631 5564 5564
16593 16593 16283 16283 5564 5564
24055 24055 23945 23945 5564 5564
25854 25854 25756 25756 5564 5564
26370 26370 26264 26264 5564 5564
26987 26987 26839 26839 5564 5564

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