albums_artists

6 rows where artist_id = 3781

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5519 5519 5263 5263 3781 3781
8684 8684 8350 8350 3781 3781
9445 9445 9098 9098 3781 3781
9446 9446 9099 9099 3781 3781
9447 9447 9100 9100 3781 3781
14147 14147 13792 13792 3781 3781

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