albums_artists

7 rows where artist_id = 1681

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1903 1903 1795 1795 1681 1681
4934 4934 4701 4701 1681 1681
5823 5823 5557 5557 1681 1681
6842 6842 6544 6544 1681 1681
7983 7983 7669 7669 1681 1681
8506 8506 8174 8174 1681 1681
26480 26480 26370 26370 1681 1681

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