albums_artists

6 rows where artist_id = 752

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
782 782 742 742 752 752
5860 5860 5593 5593 752 752
9874 9874 9528 9528 752 752
10901 10901 10560 10560 752 752
13256 13256 12912 12912 752 752
15322 15322 14981 14981 752 752

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