albums_artists

7 rows where artist_id = 9048

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18749 18749 18506 18506 9048 9048
21247 21247 21123 21123 9048 9048
22989 22989 22892 22892 9048 9048
23678 23678 23572 23572 9048 9048
24913 24913 24804 24804 9048 9048
26097 26097 25993 25993 9048 9048
26355 26355 26249 26249 9048 9048

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