albums_artists

12 rows where artist_id = 787

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
819 819 776 776 787 787
4308 4308 4104 4104 787 787
4594 4594 4377 4377 787 787
5288 5288 5041 5041 787 787
6197 6197 5917 5917 787 787
8634 8634 8299 8299 787 787
10393 10393 10052 10052 787 787
12034 12034 11695 11695 787 787
12474 12474 12137 12137 787 787
13411 13411 13061 13061 787 787
14593 14593 14239 14239 787 787
15741 15741 15404 15404 787 787

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