albums_artists

10 rows where artist_id = 614

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
634 634 610 610 614 614
18435 18435 18164 18164 614 614
19077 19077 18853 18853 614 614
21475 21475 21356 21356 614 614
22700 22700 22608 22608 614 614
22987 22987 22890 22890 614 614
24864 24864 24750 24750 614 614
25619 25619 25521 25521 614 614
26046 26046 25946 25946 614 614
26288 26288 26185 26185 614 614

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