albums_artists

5 rows where artist_id = 557

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
573 573 549 549 557 557
3285 3285 3102 3102 557 557
5841 5841 5574 5574 557 557
6585 6585 6297 6297 557 557
27169 27169 27009 27009 557 557

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