albums_artists

6 rows where artist_id = 7646

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14890 14890 14542 14542 7646 7646
16380 16380 16067 16067 7646 7646
20441 20441 20275 20275 7646 7646
23074 23074 22975 22975 7646 7646
24625 24625 24503 24503 7646 7646
25912 25912 25814 25814 7646 7646

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