albums_artists

5 rows where artist_id = 2859

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3731 3731 3532 3532 2859 2859
13397 13397 13047 13047 2859 2859
18780 18780 18538 18538 2859 2859
23160 23160 23059 23059 2859 2859
24026 24026 23915 23915 2859 2859

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