albums_artists

11 rows where artist_id = 848

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
887 887 840 840 848 848
2616 2616 2463 2463 848 848
6422 6422 6130 6130 848 848
10360 10360 10019 10019 848 848
11928 11928 11585 11585 848 848
15225 15225 14880 14880 848 848
17674 17674 17379 17379 848 848
23745 23745 23635 23635 848 848
25661 25661 25563 25563 848 848
25815 25815 25716 25716 848 848
26697 26697 26569 26569 848 848

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