albums_artists

11 rows where artist_id = 4375

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6824 6824 6527 6527 4375 4375
7419 7419 7119 7119 4375 4375
12772 12772 12430 12430 4375 4375
14075 14075 13721 13721 4375 4375
17953 17953 17661 17661 4375 4375
18838 18838 18594 18594 4375 4375
19656 19656 19455 19455 4375 4375
20342 20342 20173 20173 4375 4375
20836 20836 20686 20686 4375 4375
22155 22155 22060 22060 4375 4375
27402 27402 27229 27229 4375 4375

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