albums_artists

12 rows where artist_id = 2931

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3867 3867 3662 3662 2931 2931
6357 6357 6067 6067 2931 2931
7581 7581 7274 7274 2931 2931
10494 10494 10155 10155 2931 2931
13703 13703 13352 13352 2931 2931
15541 15541 15200 15200 2931 2931
17359 17359 17061 17061 2931 2931
18616 18616 18365 18365 2931 2931
19032 19032 18803 18803 2931 2931
21652 21652 21539 21539 2931 2931
24021 24021 23910 23910 2931 2931
26118 26118 26015 26015 2931 2931

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