albums_artists

11 rows where artist_id = 788

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
820 820 776 776 788 788
997 997 941 941 788 788
4030 4030 3829 3829 788 788
6265 6265 5979 5979 788 788
10048 10048 9703 9703 788 788
12063 12063 11722 11722 788 788
13027 13027 12687 12687 788 788
13464 13464 13112 13112 788 788
14105 14105 13750 13750 788 788
14553 14553 14198 14198 788 788
15614 15614 15276 15276 788 788

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