albums_artists

4 rows where artist_id = 1725

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1963 1963 1847 1847 1725 1725
2835 2835 2669 2669 1725 1725
5049 5049 4810 4810 1725 1725
26605 26605 26490 26490 1725 1725

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