albums_artists

10 rows where artist_id = 4178

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6416 6416 6124 6124 4178 4178
10698 10698 10362 10362 4178 4178
15290 15290 14946 14946 4178 4178
16373 16373 16059 16059 4178 4178
17694 17694 17399 17399 4178 4178
19296 19296 19078 19078 4178 4178
20959 20959 20814 20814 4178 4178
21165 21165 21038 21038 4178 4178
23858 23858 23746 23746 4178 4178
27004 27004 26855 26855 4178 4178

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