albums_artists

12 rows where artist_id = 5620

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9740 9740 9394 9394 5620 5620
12781 12781 12439 12439 5620 5620
15117 15117 14772 14772 5620 5620
15118 15118 14773 14773 5620 5620
15318 15318 14976 14976 5620 5620
15319 15319 14977 14977 5620 5620
15635 15635 15297 15297 5620 5620
15636 15636 15298 15298 5620 5620
15863 15863 15519 15519 5620 5620
18607 18607 18356 18356 5620 5620
25074 25074 24969 24969 5620 5620
26255 26255 26153 26153 5620 5620

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