albums_artists

13 rows where artist_id = 2794

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3618 3618 3422 3422 2794 2794
6947 6947 6649 6649 2794 2794
8115 8115 7798 7798 2794 2794
8831 8831 8500 8500 2794 2794
8832 8832 8501 8501 2794 2794
9505 9505 9159 9159 2794 2794
10754 10754 10420 10420 2794 2794
11353 11353 11016 11016 2794 2794
12870 12870 12527 12527 2794 2794
13259 13259 12915 12915 2794 2794
15240 15240 14895 14895 2794 2794
23823 23823 23712 23712 2794 2794
26285 26285 26182 26182 2794 2794

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