albums_artists

6 rows where artist_id = 3919

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5787 5787 5520 5520 3919 3919
20114 20114 19936 19936 3919 3919
21729 21729 21620 21620 3919 3919
22434 22434 22339 22339 3919 3919
24874 24874 24761 24761 3919 3919
26066 26066 25967 25967 3919 3919

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