albums_artists

10 rows where artist_id = 3232

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4391 4391 4180 4180 3232 3232
20822 20822 20670 20670 3232 3232
20823 20823 20671 20671 3232 3232
20824 20824 20672 20672 3232 3232
20825 20825 20673 20673 3232 3232
20934 20934 20786 20786 3232 3232
20935 20935 20787 20787 3232 3232
20936 20936 20788 20788 3232 3232
20937 20937 20789 20789 3232 3232
24274 24274 24165 24165 3232 3232

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