albums_artists

6 rows where artist_id = 1546

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1727 1727 1628 1628 1546 1546
7752 7752 7444 7444 1546 1546
10105 10105 9763 9763 1546 1546
11904 11904 11561 11561 1546 1546
12563 12563 12223 12223 1546 1546
27167 27167 27007 27007 1546 1546

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