albums_artists

5 rows where artist_id = 657

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
679 679 650 650 657 657
5440 5440 5184 5184 657 657
10781 10781 10445 10445 657 657
14730 14730 14376 14376 657 657
18026 18026 17736 17736 657 657

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