albums_artists

9 rows where artist_id = 5176

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8725 8725 8392 8392 5176 5176
12172 12172 11834 11834 5176 5176
14314 14314 13956 13956 5176 5176
14315 14315 13957 13957 5176 5176
14316 14316 13958 13958 5176 5176
14382 14382 14024 14024 5176 5176
14383 14383 14025 14025 5176 5176
15051 15051 14705 14705 5176 5176
24418 24418 24306 24306 5176 5176

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