albums_artists

9 rows where artist_id = 4052

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6061 6061 5787 5787 4052 4052
7822 7822 7510 7510 4052 4052
8995 8995 8655 8655 4052 4052
8996 8996 8656 8656 4052 4052
11857 11857 11516 11516 4052 4052
13782 13782 13426 13426 4052 4052
14259 14259 13901 13901 4052 4052
16507 16507 16193 16193 4052 4052
17312 17312 17010 17010 4052 4052

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