albums_artists

8 rows where artist_id = 4566

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7246 7246 6949 6949 4566 4566
10980 10980 10638 10638 4566 4566
14677 14677 14321 14321 4566 4566
16163 16163 15840 15840 4566 4566
18190 18190 17908 17908 4566 4566
21298 21298 21174 21174 4566 4566
23322 23322 23218 23218 4566 4566
25261 25261 25159 25159 4566 4566

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