Novels that share the most themes

Novel A	Novel B	Shared Themes
Jacques le fataliste et son m…	La religieuse @en	12
Aline et Valcour @en	Jacques le fataliste…	11
La dot de Suzette @en	Les cinquante francs…	11
La philosophie dans le boudoi…	Jacques le fataliste…	10

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 10 rows · 238 ms · no server, no download — the query runs in your browser.

The query

PREFIX wdt: <http://data.mimotext.uni-trier.de/prop/direct/> PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> SELECT ?novelA ?novelB (COUNT(?t) AS ?sharedThemes) WHERE { ?a wdt:P36 ?t . ?b wdt:P36 ?t . FILTER(STR(?a) < STR(?b)) ?a rdfs:label ?novelA FILTER(LANG(?novelA)="en") ?b rdfs:label ?novelB FILTER(LANG(?novelB)="en") } GROUP BY ?novelA ?novelB ORDER BY DESC(?sharedThemes) LIMIT 10

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