albums_artists

10 rows where artist_id = 2841

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3705 3705 3505 3505 2841 2841
9044 9044 8704 8704 2841 2841
13347 13347 12997 12997 2841 2841
14384 14384 14026 14026 2841 2841
18699 18699 18454 18454 2841 2841
19281 19281 19062 19062 2841 2841
20755 20755 20597 20597 2841 2841
22262 22262 22171 22171 2841 2841
22698 22698 22606 22606 2841 2841
22699 22699 22607 22607 2841 2841

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