albums_artists

10 rows where artist_id = 9506

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
20036 20036 19854 19854 9506 9506
20876 20876 20722 20722 9506 9506
20877 20877 20723 20723 9506 9506
21402 21402 21280 21280 9506 9506
22381 22381 22290 22290 9506 9506
22849 22849 22755 22755 9506 9506
24317 24317 24205 24205 9506 9506
24592 24592 24470 24470 9506 9506
24813 24813 24696 24696 9506 9506
25574 25574 25476 25476 9506 9506

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