albums_artists

7 rows where album_id = 16855

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17151 17151 16855 16855 636 636
17152 17152 16855 16855 3245 3245
17153 17153 16855 16855 7511 7511
17154 17154 16855 16855 8450 8450
17155 17155 16855 16855 7680 7680
17156 17156 16855 16855 8451 8451
17157 17157 16855 16855 3702 3702

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