albums_artists

9 rows where artist_id = 7856

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15535 15535 15194 15194 7856 7856
16325 16325 16011 16011 7856 7856
18821 18821 18577 18577 7856 7856
21878 21878 21774 21774 7856 7856
22689 22689 22597 22597 7856 7856
22690 22690 22598 22598 7856 7856
22691 22691 22599 22599 7856 7856
22692 22692 22600 22600 7856 7856
26010 26010 25912 25912 7856 7856

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