albums_artists

6 rows where artist_id = 628

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
648 648 621 621 628 628
2597 2597 2445 2445 628 628
6535 6535 6246 6246 628 628
9396 9396 9048 9048 628 628
12404 12404 12067 12067 628 628
15264 15264 14919 14919 628 628

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