albums_artists

12 rows where artist_id = 4154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6325 6325 6038 6038 4154 4154
8585 8585 8251 8251 4154 4154
8586 8586 8252 8252 4154 4154
12719 12719 12380 12380 4154 4154
13977 13977 13622 13622 4154 4154
20101 20101 19922 19922 4154 4154
20879 20879 20725 20725 4154 4154
23033 23033 22937 22937 4154 4154
23052 23052 22955 22955 4154 4154
25512 25512 25412 25412 4154 4154
26070 26070 25971 25971 4154 4154
26460 26460 26350 26350 4154 4154

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