albums_artists

7 rows where artist_id = 3119

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4197 4197 3995 3995 3119 3119
8451 8451 8123 8123 3119 3119
13396 13396 13046 13046 3119 3119
15286 15286 14941 14941 3119 3119
18488 18488 18221 18221 3119 3119
21261 21261 21137 21137 3119 3119
22140 22140 22044 22044 3119 3119

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