home / pf

albums_artists

7 rows where artist_id = 940

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
984 984 928 928 940 940
985 985 929 929 940 940
986 986 930 930 940 940
987 987 931 931 940 940
988 988 932 932 940 940
3976 3976 3771 3771 940 940
7877 7877 7561 7561 940 940

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)
);
Powered by Datasette · Queries took 59.193ms