albums_artists

6 rows where artist_id = 464

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
475 475 455 455 464 464
10055 10055 9709 9709 464 464
11998 11998 11657 11657 464 464
13902 13902 13543 13543 464 464
15874 15874 15530 15530 464 464
18326 18326 18051 18051 464 464

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