albums_artists

5 rows where artist_id = 9656

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
20529 20529 20367 20367 9656 9656
22048 22048 21949 21949 9656 9656
23378 23378 23276 23276 9656 9656
23379 23379 23277 23277 9656 9656
24506 24506 24388 24388 9656 9656

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