albums_artists

10 rows where artist_id = 4939

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8150 8150 7831 7831 4939 4939
13596 13596 13245 13245 4939 4939
16383 16383 16070 16070 4939 4939
18160 18160 17876 17876 4939 4939
19525 19525 19312 19312 4939 4939
19799 19799 19604 19604 4939 4939
23279 23279 23176 23176 4939 4939
23932 23932 23819 23819 4939 4939
25705 25705 25605 25605 4939 4939
26144 26144 26041 26041 4939 4939

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