albums_artists

12 rows where artist_id = 4143

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6293 6293 6007 6007 4143 4143
13817 13817 13459 13459 4143 4143
13818 13818 13460 13460 4143 4143
13819 13819 13461 13461 4143 4143
13820 13820 13462 13462 4143 4143
13821 13821 13463 13463 4143 4143
13822 13822 13464 13464 4143 4143
13823 13823 13465 13465 4143 4143
13824 13824 13466 13466 4143 4143
13825 13825 13467 13467 4143 4143
17481 17481 17187 17187 4143 4143
23087 23087 22987 22987 4143 4143

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