albums_artists

10 rows where artist_id = 964

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1015 1015 959 959 964 964
5570 5570 5311 5311 964 964
6698 6698 6407 6407 964 964
8993 8993 8653 8653 964 964
9220 9220 8876 8876 964 964
13234 13234 12892 12892 964 964
16057 16057 15729 15729 964 964
18371 18371 18096 18096 964 964
19973 19973 19785 19785 964 964
26753 26753 26622 26622 964 964

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