albums_artists

5 rows where artist_id = 10864

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
24162 24162 24053 24053 10864 10864
25690 25690 25590 25590 10864 10864
25954 25954 25855 25855 10864 10864
26054 26054 25955 25955 10864 10864
26128 26128 26025 26025 10864 10864

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