albums_artists

6 rows where artist_id = 3903

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5757 5757 5491 5491 3903 3903
13666 13666 13315 13315 3903 3903
17318 17318 17016 17016 3903 3903
22567 22567 22473 22473 3903 3903
22669 22669 22576 22576 3903 3903
25773 25773 25674 25674 3903 3903

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