albums_artists

6 rows where artist_id = 790

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
822 822 777 777 790 790
2330 2330 2186 2186 790 790
4171 4171 3970 3970 790 790
6386 6386 6096 6096 790 790
9179 9179 8836 8836 790 790
26601 26601 26486 26486 790 790

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