albums_artists

9 rows where artist_id = 4397

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6869 6869 6570 6570 4397 4397
9706 9706 9359 9359 4397 4397
11821 11821 11480 11480 4397 4397
12399 12399 12063 12063 4397 4397
13874 13874 13517 13517 4397 4397
15334 15334 14993 14993 4397 4397
16255 16255 15933 15933 4397 4397
16675 16675 16365 16365 4397 4397
17828 17828 17537 17537 4397 4397

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