albums_artists

5 rows where artist_id = 477

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
489 489 467 467 477 477
7018 7018 6719 6719 477 477
9921 9921 9575 9575 477 477
11777 11777 11437 11437 477 477
13076 13076 12739 12739 477 477

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