albums_artists

11 rows where artist_id = 2535

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3173 3173 2995 2995 2535 2535
7660 7660 7354 7354 2535 2535
9388 9388 9040 9040 2535 2535
12841 12841 12498 12498 2535 2535
15029 15029 14682 14682 2535 2535
15200 15200 14855 14855 2535 2535
16307 16307 15992 15992 2535 2535
18005 18005 17715 17715 2535 2535
21008 21008 20863 20863 2535 2535
23601 23601 23498 23498 2535 2535
25797 25797 25698 25698 2535 2535

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