albums_artists

9 rows where artist_id = 3521

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4959 4959 4726 4726 3521 3521
4960 4960 4727 4727 3521 3521
4961 4961 4728 4728 3521 3521
10524 10524 10186 10186 3521 3521
10525 10525 10187 10187 3521 3521
20626 20626 20463 20463 3521 3521
20627 20627 20464 20464 3521 3521
26217 26217 26115 26115 3521 3521
27460 27460 27285 27285 3521 3521

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