albums_artists

5 rows where artist_id = 1052

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1112 1112 1050 1050 1052 1052
3634 3634 3438 3438 1052 1052
9214 9214 8871 8871 1052 1052
10443 10443 10101 10101 1052 1052
11529 11529 11191 11191 1052 1052

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