albums_artists

7 rows where artist_id = 805

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
839 839 793 793 805 805
4181 4181 3979 3979 805 805
9241 9241 8896 8896 805 805
15920 15920 15580 15580 805 805
17360 17360 17062 17062 805 805
19884 19884 19695 19695 805 805
22346 22346 22256 22256 805 805

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