albums_artists

13 rows where artist_id = 3793

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5553 5553 5295 5295 3793 3793
7803 7803 7491 7491 3793 3793
11590 11590 11252 11252 3793 3793
14487 14487 14131 14131 3793 3793
15786 15786 15447 15447 3793 3793
17689 17689 17394 17394 3793 3793
19009 19009 18778 18778 3793 3793
19986 19986 19800 19800 3793 3793
20963 20963 20818 20818 3793 3793
21806 21806 21700 21700 3793 3793
22263 22263 22172 22172 3793 3793
23351 23351 23249 23249 3793 3793
25116 25116 25012 25012 3793 3793

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