albums_artists

11 rows where artist_id = 635

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
656 656 629 629 635 635
13714 13714 13361 13361 635 635
15573 15573 15232 15232 635 635
17486 17486 17192 17192 635 635
20124 20124 19947 19947 635 635
20125 20125 19948 19948 635 635
20126 20126 19949 19949 635 635
21709 21709 21598 21598 635 635
21710 21710 21599 21599 635 635
21711 21711 21600 21600 635 635
22177 22177 22083 22083 635 635

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