albums_artists

11 rows where artist_id = 387

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
396 396 377 377 387 387
755 755 717 717 387 387
10110 10110 9768 9768 387 387
10692 10692 10358 10358 387 387
11782 11782 11442 11442 387 387
15276 15276 14931 14931 387 387
17060 17060 16757 16757 387 387
20515 20515 20352 20352 387 387
20842 20842 20690 20690 387 387
21513 21513 21392 21392 387 387
24248 24248 24139 24139 387 387

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