albums_artists

5 rows where artist_id = 847

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
886 886 839 839 847 847
2089 2089 1961 1961 847 847
3340 3340 3155 3155 847 847
4173 4173 3972 3972 847 847
5286 5286 5039 5039 847 847

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