albums_artists

7 rows where artist_id = 1787

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2048 2048 1924 1924 1787 1787
6424 6424 6132 6132 1787 1787
10786 10786 10449 10449 1787 1787
14459 14459 14102 14102 1787 1787
17538 17538 17244 17244 1787 1787
20132 20132 19955 19955 1787 1787
21366 21366 21243 21243 1787 1787

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