albums_artists

5 rows where artist_id = 5587

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9665 9665 9319 9319 5587 5587
12655 12655 12315 12315 5587 5587
15085 15085 14740 14740 5587 5587
17287 17287 16983 16983 5587 5587
19723 19723 19527 19527 5587 5587

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