albums_artists

6 rows where artist_id = 269

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
276 276 264 264 269 269
800 800 760 760 269 269
3827 3827 3626 3626 269 269
6871 6871 6572 6572 269 269
9022 9022 8682 8682 269 269
10612 10612 10275 10275 269 269

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