albums_artists

5 rows where artist_id = 6110

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10863 10863 10525 10525 6110 6110
13330 13330 12983 12983 6110 6110
20311 20311 20141 20141 6110 6110
23021 23021 22925 22925 6110 6110
24989 24989 24881 24881 6110 6110

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