albums_artists

7 rows where artist_id = 3912

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5777 5777 5510 5510 3912 3912
9507 9507 9161 9161 3912 3912
15771 15771 15434 15434 3912 3912
17601 17601 17306 17306 3912 3912
20659 20659 20496 20496 3912 3912
23101 23101 23000 23000 3912 3912
24093 24093 23983 23983 3912 3912

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