albums_artists

5 rows where artist_id = 1560

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1745 1745 1646 1646 1560 1560
8160 8160 7841 7841 1560 1560
13218 13218 12876 12876 1560 1560
19054 19054 18827 18827 1560 1560
21822 21822 21719 21719 1560 1560

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