albums_artists

9 rows where artist_id = 2997

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3977 3977 3772 3772 2997 2997
5678 5678 5415 5415 2997 2997
7484 7484 7180 7180 2997 2997
11230 11230 10893 10893 2997 2997
12535 12535 12196 12196 2997 2997
13338 13338 12990 12990 2997 2997
14542 14542 14186 14186 2997 2997
14543 14543 14187 14187 2997 2997
20519 20519 20357 20357 2997 2997

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