albums_artists

7 rows where artist_id = 1682

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1904 1904 1796 1796 1682 1682
3807 3807 3605 3605 1682 1682
10392 10392 10051 10051 1682 1682
13868 13868 13511 13511 1682 1682
15723 15723 15386 15386 1682 1682
17049 17049 16746 16746 1682 1682
21481 21481 21362 21362 1682 1682

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