albums_artists

5 rows where artist_id = 586

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
605 605 581 581 586 586
4933 4933 4700 4700 586 586
5727 5727 5464 5464 586 586
11046 11046 10705 10705 586 586
13098 13098 12760 12760 586 586

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