albums_artists

23 rows where artist_id = 476

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
488 488 466 466 476 476
1550 1550 1461 1461 476 476
3974 3974 3769 3769 476 476
4421 4421 4208 4208 476 476
5305 5305 5057 5057 476 476
5980 5980 5709 5709 476 476
6576 6576 6288 6288 476 476
7303 7303 7007 7007 476 476
8732 8732 8399 8399 476 476
8845 8845 8513 8513 476 476
9989 9989 9644 9644 476 476
10089 10089 9744 9744 476 476
10412 10412 10071 10071 476 476
11632 11632 11295 11295 476 476
12401 12401 12065 12065 476 476
12715 12715 12376 12376 476 476
13269 13269 12925 12925 476 476
13798 13798 13443 13443 476 476
14330 14330 13973 13973 476 476
15554 15554 15212 15212 476 476
16638 16638 16327 16327 476 476
16639 16639 16328 16328 476 476
27477 27477 27301 27301 476 476

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