albums_artists

12 rows where artist_id = 663

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
685 685 656 656 663 663
1304 1304 1225 1225 663 663
2487 2487 2336 2336 663 663
4431 4431 4218 4218 663 663
4811 4811 4592 4592 663 663
5543 5543 5286 5286 663 663
6838 6838 6541 6541 663 663
6999 6999 6699 6699 663 663
7960 7960 7646 7646 663 663
8547 8547 8214 8214 663 663
10310 10310 9967 9967 663 663
27212 27212 27051 27051 663 663

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