Clojurians Log v2

Would SELECT DISTINCT be helpful here?

i.e. if you’re trying to remove dupes (as opposed to specifically querying for dupes) of a certain type, would the following query be helpful?

SELECT DISTINCT ?s
WHERE {
  ?s a my:Type
}

If on the other hand you’re trying to specifically find duplicates I think you need to use the COUNT aggregate and use filters to return when the count > 1

Ah I think HAVING would be your friend here (not sure if this query actually works but could be worth a shot):

SELECT ?s
WHERE {
  ?s a my:Type
  ?s ?p ?o
}
GROUP BY ?p ?o
HAVING (COUNT(?s) > 1)

Thanks, @kelvin063!

select ?s
where{
  ?s a mytype .
  ?s ?p ?o .
  ?s2 a mytype .
  ?s2 ?p ?o .
  FILTER (?s != ?s2)
  MINUS{
    ?s ?px ?ox .
    NOT EXISTS { ?s2 ?px ?ox }
  } 
}

This matches ?s and ?s2 where they are both mytype and they share any properties at all. Then remove any instance of ?s where there is a property/value and the matching ?s2 does not have that property/value

if ?s has fewer properties than ?s2 then it will be taken away via the MINUS, but then when the bindings are the other way around ?s will have more properties than ?s2 and so it won’t be removed via the minus. Which I think works here

The problem is that the above works via a nested loop in the query engine. It doesn’t scale

Yeah…

Thanks @quoll!