albums_artists

5 rows where artist_id = 703

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
729 729 696 696 703 703
2929 2929 2759 2759 703 703
5433 5433 5179 5179 703 703
7139 7139 6840 6840 703 703
8495 8495 8165 8165 703 703

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