albums_artists

5 rows where artist_id = 9914

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21331 21331 21206 21206 9914 9914
23390 23390 23287 23287 9914 9914
25297 25297 25198 25198 9914 9914
25870 25870 25772 25772 9914 9914
26222 26222 26120 26120 9914 9914

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