albums_artists

8 rows where artist_id = 466

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
477 477 457 457 466 466
848 848 802 802 466 466
5234 5234 4989 4989 466 466
5768 5768 5502 5502 466 466
7795 7795 7484 7484 466 466
10651 10651 10318 10318 466 466
13321 13321 12974 12974 466 466
23273 23273 23171 23171 466 466

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