albums_artists

5 rows where artist_id = 9027

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18672 18672 18424 18424 9027 9027
21468 21468 21349 21349 9027 9027
22113 22113 22016 22016 9027 9027
23599 23599 23496 23496 9027 9027
23731 23731 23622 23622 9027 9027

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