albums_artists

7 rows where artist_id = 3511

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4928 4928 4695 4695 3511 3511
14651 14651 14296 14296 3511 3511
14652 14652 14297 14297 3511 3511
14653 14653 14298 14298 3511 3511
14654 14654 14299 14299 3511 3511
14655 14655 14300 14300 3511 3511
14656 14656 14301 14301 3511 3511

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