albums_artists

8 rows where artist_id = 491

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
503 503 481 481 491 491
1932 1932 1821 1821 491 491
2638 2638 2482 2482 491 491
3267 3267 3084 3084 491 491
13722 13722 13368 13368 491 491
16523 16523 16209 16209 491 491
19272 19272 19053 19053 491 491
22785 22785 22695 22695 491 491

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