albums_artists

5 rows where artist_id = 8006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15977 15977 15638 15638 8006 8006
20841 20841 20689 20689 8006 8006
24156 24156 24047 24047 8006 8006
24473 24473 24358 24358 8006 8006
25964 25964 25865 25865 8006 8006

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