albums_artists

12 rows where artist_id = 1081

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1155 1155 1087 1087 1081 1081
3939 3939 3737 3737 1081 1081
7053 7053 6756 6756 1081 1081
8804 8804 8471 8471 1081 1081
9153 9153 8810 8810 1081 1081
11008 11008 10666 10666 1081 1081
12981 12981 12638 12638 1081 1081
13689 13689 13337 13337 1081 1081
14904 14904 14558 14558 1081 1081
15392 15392 15048 15048 1081 1081
18253 18253 17975 17975 1081 1081
20149 20149 19972 19972 1081 1081

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