albums_artists

18 rows where artist_id = 2795

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3620 3620 3424 3424 2795 2795
5037 5037 4798 4798 2795 2795
5794 5794 5527 5527 2795 2795
7086 7086 6787 6787 2795 2795
9917 9917 9571 9571 2795 2795
11346 11346 11010 11010 2795 2795
12834 12834 12491 12491 2795 2795
13203 13203 12861 12861 2795 2795
15113 15113 14768 14768 2795 2795
16065 16065 15737 15737 2795 2795
16541 16541 16228 16228 2795 2795
17555 17555 17261 17261 2795 2795
18049 18049 17758 17758 2795 2795
18653 18653 18404 18404 2795 2795
21206 21206 21080 21080 2795 2795
21382 21382 21260 21260 2795 2795
22675 22675 22582 22582 2795 2795
22676 22676 22583 22583 2795 2795

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