albums_artists

15 rows where artist_id = 636

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
657 657 630 630 636 636
2659 2659 2499 2499 636 636
4466 4466 4251 4251 636 636
8613 8613 8278 8278 636 636
12274 12274 11937 11937 636 636
12694 12694 12354 12354 636 636
15474 15474 15134 15134 636 636
17151 17151 16855 16855 636 636
18110 18110 17824 17824 636 636
20474 20474 20310 20310 636 636
22839 22839 22744 22744 636 636
23534 23534 23430 23430 636 636
24247 24247 24138 24138 636 636
25755 25755 25656 25656 636 636
27314 27314 27146 27146 636 636

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