albums_artists

7 rows where artist_id = 4946

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8178 8178 7860 7860 4946 4946
14603 14603 14249 14249 4946 4946
18289 18289 18011 18011 4946 4946
21945 21945 21845 21845 4946 4946
23398 23398 23295 23295 4946 4946
23759 23759 23650 23650 4946 4946
24166 24166 24057 24057 4946 4946

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