albums_artists

13 rows where artist_id = 483

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
495 495 473 473 483 483
3414 3414 3222 3222 483 483
3630 3630 3434 3434 483 483
10198 10198 9858 9858 483 483
12656 12656 12316 12316 483 483
14801 14801 14448 14448 483 483
17168 17168 16864 16864 483 483
17490 17490 17196 17196 483 483
19854 19854 19660 19660 483 483
22111 22111 22014 22014 483 483
24169 24169 24060 24060 483 483
25201 25201 25097 25097 483 483
25460 25460 25360 25360 483 483

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