albums_artists

4 rows where artist_id = 633

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
654 654 627 627 633 633
2014 2014 1895 1895 633 633
2015 2015 1896 1896 633 633
27467 27467 27292 27292 633 633

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