albums_artists

7 rows where artist_id = 2619

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3317 3317 3133 3133 2619 2619
7130 7130 6831 6831 2619 2619
10353 10353 10011 10011 2619 2619
11340 11340 11004 11004 2619 2619
13580 13580 13229 13229 2619 2619
14877 14877 14530 14530 2619 2619
26516 26516 26405 26405 2619 2619

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