albums_artists

5 rows where artist_id = 5031

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8384 8384 8060 8060 5031 5031
16973 16973 16665 16665 5031 5031
20343 20343 20174 20174 5031 5031
24649 24649 24526 24526 5031 5031
24876 24876 24764 24764 5031 5031

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