albums_artists

11 rows where artist_id = 2510

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3138 3138 2960 2960 2510 2510
7966 7966 7651 7651 2510 2510
7967 7967 7652 7652 2510 2510
7968 7968 7653 7653 2510 2510
7969 7969 7654 7654 2510 2510
7970 7970 7655 7655 2510 2510
7971 7971 7656 7656 2510 2510
7972 7972 7657 7657 2510 2510
17351 17351 17051 17051 2510 2510
19704 19704 19506 19506 2510 2510
26998 26998 26849 26849 2510 2510

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