albums_artists

8 rows where artist_id = 4093

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6169 6169 5890 5890 4093 4093
8896 8896 8561 8561 4093 4093
12021 12021 11680 11680 4093 4093
14857 14857 14509 14509 4093 4093
18929 18929 18690 18690 4093 4093
20598 20598 20432 20432 4093 4093
22447 22447 22351 22351 4093 4093
24465 24465 24353 24353 4093 4093

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