albums_artists

5 rows where artist_id = 3895

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5738 5738 5474 5474 3895 3895
12435 12435 12096 12096 3895 3895
19433 19433 19217 19217 3895 3895
24422 24422 24310 24310 3895 3895
25601 25601 25503 25503 3895 3895

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