albums_artists

4 rows where artist_id = 2726

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3492 3492 3296 3296 2726 2726
3493 3493 3297 3297 2726 2726
4657 4657 4440 4440 2726 2726
15348 15348 15006 15006 2726 2726

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