albums_artists

9 rows where artist_id = 7838

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15469 15469 15130 15130 7838 7838
16339 16339 16024 16024 7838 7838
20513 20513 20350 20350 7838 7838
20514 20514 20351 20351 7838 7838
22466 22466 22370 22370 7838 7838
23676 23676 23570 23570 7838 7838
24137 24137 24027 24027 7838 7838
25327 25327 25226 25226 7838 7838
25579 25579 25481 25481 7838 7838

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