albums_artists

5 rows where artist_id = 8720

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17818 17818 17527 17527 8720 8720
20010 20010 19825 19825 8720 8720
23524 23524 23419 23419 8720 8720
24027 24027 23916 23916 8720 8720
26731 26731 26602 26602 8720 8720

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