albums_artists

14 rows where artist_id = 386

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
395 395 376 376 386 386
5791 5791 5524 5524 386 386
7489 7489 7185 7185 386 386
12573 12573 12233 12233 386 386
14388 14388 14030 14030 386 386
16644 16644 16333 16333 386 386
17807 17807 17516 17516 386 386
20278 20278 20103 20103 386 386
21540 21540 21420 21420 386 386
22229 22229 22138 22138 386 386
23304 23304 23200 23200 386 386
24189 24189 24078 24078 386 386
24406 24406 24294 24294 386 386
25479 25479 25378 25378 386 386

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