albums_artists

9 rows where artist_id = 2796

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3622 3622 3425 3425 2796 2796
4149 4149 3948 3948 2796 2796
4527 4527 4310 4310 2796 2796
5861 5861 5594 5594 2796 2796
5898 5898 5630 5630 2796 2796
6939 6939 6641 6641 2796 2796
8784 8784 8453 8453 2796 2796
9766 9766 9420 9420 2796 2796
26439 26439 26332 26332 2796 2796

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