albums_artists

5 rows where artist_id = 1525

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1702 1702 1604 1604 1525 1525
10723 10723 10389 10389 1525 1525
14614 14614 14259 14259 1525 1525
15521 15521 15180 15180 1525 1525
16524 16524 16210 16210 1525 1525

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