albums_artists

8 rows where artist_id = 2488

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3106 3106 2928 2928 2488 2488
12276 12276 11939 11939 2488 2488
13645 13645 13294 13294 2488 2488
17521 17521 17226 17226 2488 2488
18927 18927 18688 18688 2488 2488
20451 20451 20285 20285 2488 2488
21052 21052 20911 20911 2488 2488
22009 22009 21909 21909 2488 2488

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