albums_artists

12 rows where artist_id = 3658

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5270 5270 5025 5025 3658 3658
6505 6505 6214 6214 3658 3658
8517 8517 8185 8185 3658 3658
8820 8820 8489 8489 3658 3658
10243 10243 9904 9904 3658 3658
13626 13626 13275 13275 3658 3658
15246 15246 14901 14901 3658 3658
18725 18725 18481 18481 3658 3658
24614 24614 24492 24492 3658 3658
25926 25926 25828 25828 3658 3658
26221 26221 26119 26119 3658 3658
26358 26358 26252 26252 3658 3658

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