albums_artists

6 rows where artist_id = 3814

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5592 5592 5333 5333 3814 3814
7592 7592 7285 7285 3814 3814
9120 9120 8777 8777 3814 3814
11835 11835 11494 11494 3814 3814
13175 13175 12835 12835 3814 3814
27039 27039 26889 26889 3814 3814

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