BODS RDF - Identifying ultimate parents for a target

find-ultimate-parents.sparql

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf:     <http://xmlns.com/foaf/0.1/>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>

SELECT ?ultimateParent ?ultimateParentName
WHERE  {
    ?ultimateParent bods:ownsOrControls+ bods-res:openownership-register-12337862642105981237 .
    ?ultimateParent foaf:name ?ultimateParentName .
    ?ultimateParent rdf:type bods:Entity .

    # An ultimate parent is an entity that isn't controlled by another entity
    FILTER NOT EXISTS {
       ?s bods:ownsOrControls ?ultimateParent .
       ?s rdf:type bods:Entity .
    }
}