albums_artists

7 rows where artist_id = 3822

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5601 5601 5341 5341 3822 3822
9438 9438 9091 9091 3822 3822
10149 10149 9809 9809 3822 3822
12158 12158 11819 11819 3822 3822
17100 17100 16798 16798 3822 3822
21003 21003 20858 20858 3822 3822
23153 23153 23052 23052 3822 3822

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