albums_artists

8 rows where artist_id = 456

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
467 467 447 447 456 456
1813 1813 1712 1712 456 456
3031 3031 2856 2856 456 456
5815 5815 5548 5548 456 456
6527 6527 6237 6237 456 456
7263 7263 6966 6966 456 456
8140 8140 7821 7821 456 456
8938 8938 8601 8601 456 456

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