albums_artists

7 rows where artist_id = 1491

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1651 1651 1557 1557 1491 1491
5683 5683 5420 5420 1491 1491
9881 9881 9534 9534 1491 1491
13081 13081 12744 12744 1491 1491
13605 13605 13254 13254 1491 1491
16381 16381 16068 16068 1491 1491
18921 18921 18681 18681 1491 1491

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