albums_artists

5 rows where artist_id = 4871

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7987 7987 7673 7673 4871 4871
11208 11208 10870 10870 4871 4871
14107 14107 13752 13752 4871 4871
16796 16796 16488 16488 4871 4871
19528 19528 19315 19315 4871 4871

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