albums_artists

9 rows where artist_id = 4179

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6417 6417 6125 6125 4179 4179
27342 27342 27173 27173 4179 4179
27343 27343 27174 27174 4179 4179
27344 27344 27175 27175 4179 4179
27345 27345 27176 27176 4179 4179
27346 27346 27177 27177 4179 4179
27347 27347 27178 27178 4179 4179
27348 27348 27179 27179 4179 4179
27349 27349 27180 27180 4179 4179

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