albums_artists

9 rows where artist_id = 4787

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7779 7779 7470 7470 4787 4787
10331 10331 9988 9988 4787 4787
20851 20851 20698 20698 4787 4787
22368 22368 22277 22277 4787 4787
24378 24378 24265 24265 4787 4787
25251 25251 25149 25149 4787 4787
25822 25822 25723 25723 4787 4787
26089 26089 25985 25985 4787 4787
26339 26339 26233 26233 4787 4787

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