albums_artists

6 rows where artist_id = 8979

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18531 18531 18270 18270 8979 8979
19367 19367 19151 19151 8979 8979
21761 21761 21653 21653 8979 8979
24691 24691 24569 24569 8979 8979
26049 26049 25950 25950 8979 8979
26212 26212 26110 26110 8979 8979

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