albums_artists

7 rows where artist_id = 2524

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3157 3157 2979 2979 2524 2524
4821 4821 4602 4602 2524 2524
7002 7002 6703 6703 2524 2524
10753 10753 10419 10419 2524 2524
14220 14220 13859 13859 2524 2524
16229 16229 15908 15908 2524 2524
26960 26960 26813 26813 2524 2524

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