albums_artists

6 rows where artist_id = 5740

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9976 9976 9631 9631 5740 5740
11607 11607 11270 11270 5740 5740
12085 12085 11744 11744 5740 5740
13510 13510 13159 13159 5740 5740
14886 14886 14538 14538 5740 5740
15740 15740 15403 15403 5740 5740

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