albums_artists

17 rows where artist_id = 4688

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7528 7528 7223 7223 4688 4688
7529 7529 7224 7224 4688 4688
7530 7530 7225 7225 4688 4688
7531 7531 7226 7226 4688 4688
7532 7532 7227 7227 4688 4688
7533 7533 7228 7228 4688 4688
7534 7534 7229 7229 4688 4688
7535 7535 7230 7230 4688 4688
7536 7536 7231 7231 4688 4688
7537 7537 7232 7232 4688 4688
7538 7538 7233 7233 4688 4688
7539 7539 7234 7234 4688 4688
7540 7540 7235 7235 4688 4688
7541 7541 7236 7236 4688 4688
7542 7542 7237 7237 4688 4688
12681 12681 12341 12341 4688 4688
27480 27480 27304 27304 4688 4688

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