albums_artists

9 rows where artist_id = 4481

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7044 7044 6747 6747 4481 4481
12132 12132 11793 11793 4481 4481
14905 14905 14559 14559 4481 4481
14969 14969 14619 14619 4481 4481
16777 16777 16469 16469 4481 4481
18417 18417 18147 18147 4481 4481
18550 18550 18292 18292 4481 4481
21842 21842 21738 21738 4481 4481
23571 23571 23467 23467 4481 4481

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