albums_artists

15 rows where artist_id = 3905

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5759 5759 5493 5493 3905 3905
5760 5760 5494 5494 3905 3905
5761 5761 5495 5495 3905 3905
5762 5762 5496 5496 3905 3905
5763 5763 5497 5497 3905 3905
5764 5764 5498 5498 3905 3905
5765 5765 5499 5499 3905 3905
13921 13921 13563 13563 3905 3905
16207 16207 15886 15886 3905 3905
19819 19819 19624 19624 3905 3905
22435 22435 22340 22340 3905 3905
25001 25001 24894 24894 3905 3905
25002 25002 24895 24895 3905 3905
25494 25494 25393 25393 3905 3905
26342 26342 26236 26236 3905 3905

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