reteplayground
Aggregate

Which drawings share a cast

Drawing…and drawingShared actors+1
Gerry Bull, Space Research Co…Gerry Bull, Space Res…49
George W. Bush, Harken Energy…George W. Bush, Harke…41
Global Int'l Airways and Indi…Global International…17
Mary Carter Resorts Study Fro…Untitled (TCSPF Aladd…13
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 40 rows · 390 ms · no server, no download — the query runs in your browser.

The query

PREFIX lo: <https://w3id.org/rete/lombardi/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?drawingA ?drawingB ?sharedActors ?jaccard WHERE { ?o a lo:Overlap ; lo:sharedActorCount ?sharedActors ; lo:jaccard ?jaccard ; lo:betweenDrawing ?wa , ?wb . ?wa rdfs:label ?drawingA . ?wb rdfs:label ?drawingB . FILTER(STR(?drawingA) < STR(?drawingB)) } ORDER BY DESC(?sharedActors) LIMIT 40

rete playground · documentation · github.com/caviri/rete