albums_artists

5 rows where artist_id = 789

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
821 821 776 776 789 789
5632 5632 5370 5370 789 789
7385 7385 7087 7087 789 789
8544 8544 8211 8211 789 789
10932 10932 10591 10591 789 789

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