albums_artists

5 rows where artist_id = 756

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
786 786 746 746 756 756
2855 2855 2688 2688 756 756
8736 8736 8403 8403 756 756
21930 21930 21829 21829 756 756
21931 21931 21830 21830 756 756

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