albums_artists

11 rows where artist_id = 596

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
616 616 592 592 596 596
8707 8707 8375 8375 596 596
11285 11285 10948 10948 596 596
13566 13566 13214 13214 596 596
15961 15961 15622 15622 596 596
18022 18022 17732 17732 596 596
19397 19397 19181 19181 596 596
20469 20469 20304 20304 596 596
22088 22088 21991 21991 596 596
22627 22627 22535 22535 596 596
24340 24340 24227 24227 596 596

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