albums_artists

4 rows where artist_id = 458

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
469 469 449 449 458 458
3994 3994 3791 3791 458 458
6376 6376 6087 6087 458 458
8705 8705 8373 8373 458 458

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