albums_artists

10 rows where artist_id = 2527

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3161 3161 2983 2983 2527 2527
15965 15965 15626 15626 2527 2527
17167 17167 16863 16863 2527 2527
21990 21990 21890 21890 2527 2527
23406 23406 23302 23302 2527 2527
23878 23878 23766 23766 2527 2527
24559 24559 24439 24439 2527 2527
25101 25101 24998 24998 2527 2527
25669 25669 25569 25569 2527 2527
25999 25999 25900 25900 2527 2527

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