albums_artists

10 rows where artist_id = 4485

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7055 7055 6758 6758 4485 4485
8932 8932 8596 8596 4485 4485
12107 12107 11768 11768 4485 4485
16632 16632 16321 16321 4485 4485
20039 20039 19856 19856 4485 4485
22127 22127 22031 22031 4485 4485
22439 22439 22344 22344 4485 4485
23455 23455 23350 23350 4485 4485
23864 23864 23752 23752 4485 4485
24131 24131 24021 24021 4485 4485

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