albums_artists

9 rows where artist_id = 2748

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3531 3531 3334 3334 2748 2748
3532 3532 3335 3335 2748 2748
3533 3533 3336 3336 2748 2748
3534 3534 3337 3337 2748 2748
3535 3535 3338 3338 2748 2748
3536 3536 3339 3339 2748 2748
3537 3537 3340 3340 2748 2748
8843 8843 8511 8511 2748 2748
23617 23617 23514 23514 2748 2748

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