albums_artists

8 rows where artist_id = 2659

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3378 3378 3187 3187 2659 2659
5154 5154 4911 4911 2659 2659
8614 8614 8279 8279 2659 2659
11989 11989 11647 11647 2659 2659
12865 12865 12522 12522 2659 2659
14949 14949 14599 14599 2659 2659
15597 15597 15258 15258 2659 2659
27270 27270 27105 27105 2659 2659

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