albums_artists

7 rows where artist_id = 5716

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9935 9935 9589 9589 5716 5716
12000 12000 11659 11659 5716 5716
12799 12799 12457 12457 5716 5716
14859 14859 14511 14511 5716 5716
15660 15660 15322 15322 5716 5716
16703 16703 16393 16393 5716 5716
18476 18476 18208 18208 5716 5716

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