albums_artists

6 rows where artist_id = 565

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
582 582 558 558 565 565
4404 4404 4192 4192 565 565
5022 5022 4784 4784 565 565
5800 5800 5532 5532 565 565
6899 6899 6600 6600 565 565
8876 8876 8541 8541 565 565

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