albums_artists

10 rows where artist_id = 1831

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2110 2110 1981 1981 1831 1831
2826 2826 2660 2660 1831 1831
4958 4958 4725 4725 1831 1831
7299 7299 7003 7003 1831 1831
9334 9334 8986 8986 1831 1831
10919 10919 10578 10578 1831 1831
13658 13658 13307 13307 1831 1831
14861 14861 14513 14513 1831 1831
15123 15123 14778 14778 1831 1831
15124 15124 14779 14779 1831 1831

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