albums_artists

4 rows where artist_id = 9731

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
20735 20735 20577 20577 9731 9731
20736 20736 20578 20578 9731 9731
22870 22870 22775 22775 9731 9731
24670 24670 24547 24547 9731 9731

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