BODS RDF - Ultimate parents ownership chain

ultimate-parents-ownership-chain.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 ?parentName ?childName
WHERE {
    ?ultimateParent bods:ownsOrControls* ?parent .
    ?ultimateParent rdf:type bods:Entity .
    ?parent foaf:name ?parentName .
    ?parent bods:ownsOrControls ?child .
    ?child foaf:name ?childName .
    ?child bods:ownsOrControls* bods-res:openownership-register-12337862642105981237.

    FILTER NOT EXISTS {
        ?s bods:ownsOrControls ?ultimateParent .
        ?s rdf:type bods:Entity .
    }
}
GROUP BY ?parentName ?childName # To avoid duplicate entries