albums_artists

6 rows where artist_id = 2887

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3781 3781 3581 3581 2887 2887
3782 3782 3582 3582 2887 2887
3783 3783 3583 3583 2887 2887
3784 3784 3584 3584 2887 2887
4448 4448 4234 4234 2887 2887
18928 18928 18689 18689 2887 2887

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