albums_artists

5 rows where artist_id = 8884

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18285 18285 18007 18007 8884 8884
19864 19864 19671 19671 8884 8884
21556 21556 21440 21440 8884 8884
23977 23977 23864 23864 8884 8884
24209 24209 24098 24098 8884 8884

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