albums_artists

14 rows where artist_id = 8376

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16962 16962 16654 16654 8376 8376
18917 18917 18676 18676 8376 8376
21353 21353 21230 21230 8376 8376
21626 21626 21513 21513 8376 8376
21627 21627 21514 21514 8376 8376
21628 21628 21515 21515 8376 8376
21629 21629 21516 21516 8376 8376
21630 21630 21517 21517 8376 8376
21746 21746 21637 21637 8376 8376
22089 22089 21992 21992 8376 8376
22488 22488 22392 22392 8376 8376
23797 23797 23687 23687 8376 8376
25648 25648 25550 25550 8376 8376
26008 26008 25910 25910 8376 8376

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