albums_artists

8 rows where artist_id = 625

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
645 645 618 618 625 625
8690 8690 8356 8356 625 625
8691 8691 8357 8357 625 625
8692 8692 8358 8358 625 625
13267 13267 12923 12923 625 625
19787 19787 19592 19592 625 625
24483 24483 24366 24366 625 625
26254 26254 26152 26152 625 625

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