albums_artists

4 rows where artist_id = 8899

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18322 18322 18047 18047 8899 8899
21983 21983 21883 21883 8899 8899
25597 25597 25499 25499 8899 8899
25987 25987 25888 25888 8899 8899

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