albums_artists

12 rows where artist_id = 4723

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7632 7632 7326 7326 4723 4723
7949 7949 7635 7635 4723 4723
7950 7950 7636 7636 4723 4723
7951 7951 7637 7637 4723 4723
7952 7952 7638 7638 4723 4723
7953 7953 7639 7639 4723 4723
7954 7954 7640 7640 4723 4723
7955 7955 7641 7641 4723 4723
7956 7956 7642 7642 4723 4723
7957 7957 7643 7643 4723 4723
7958 7958 7644 7644 4723 4723
24604 24604 24482 24482 4723 4723

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