albums_artists

6 rows where artist_id = 749

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
779 779 739 739 749 749
1032 1032 976 976 749 749
1125 1125 1062 1062 749 749
1610 1610 1521 1521 749 749
1927 1927 1816 1816 749 749
2269 2269 2127 2127 749 749

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