albums_artists

8 rows where artist_id = 6939

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12875 12875 12532 12532 6939 6939
14024 14024 13670 13670 6939 6939
15586 15586 15247 15247 6939 6939
16914 16914 16604 16604 6939 6939
18548 18548 18290 18290 6939 6939
20857 20857 20704 20704 6939 6939
21750 21750 21642 21642 6939 6939
22345 22345 22255 22255 6939 6939

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