albums_artists

14 rows where artist_id = 929

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
972 972 917 917 929 929
4595 4595 4377 4377 929 929
4844 4844 4623 4623 929 929
9678 9678 9330 9330 929 929
10974 10974 10633 10633 929 929
12035 12035 11695 11695 929 929
12268 12268 11931 11931 929 929
13149 13149 12810 12810 929 929
13473 13473 13121 13121 929 929
14059 14059 13705 13705 929 929
14294 14294 13936 13936 929 929
14495 14495 14139 14139 929 929
14995 14995 14647 14647 929 929
15402 15402 15059 15059 929 929

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