albums_artists

5 rows where artist_id = 9866

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21169 21169 21042 21042 9866 9866
23083 23083 22983 22983 9866 9866
23482 23482 23376 23376 9866 9866
23893 23893 23780 23780 9866 9866
25093 25093 24990 24990 9866 9866

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