albums_artists

6 rows where artist_id = 6869

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12673 12673 12333 12333 6869 6869
14518 14518 14162 14162 6869 6869
16391 16391 16078 16078 6869 6869
17250 17250 16947 16947 6869 6869
18491 18491 18225 18225 6869 6869
19467 19467 19250 19250 6869 6869

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