BODS RDF - All the entities connected to a target: entities with control over the target or which the target controls (directly or indirectly)

query.sparql

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

SELECT ?companyName ?relationship
WHERE {
    ?company rdf:type bods:Entity .
    ?company foaf:name ?companyName .
    {
        ?company bods:ownsOrControls+ bods-res:openownership-register-227513236687367494 .
        BIND("Controls target" AS ?relationship)
    }
    UNION
    {
        bods-res:openownership-register-227513236687367494 bods:ownsOrControls+ ?company .    
        BIND("Is controlled by target" AS ?relationship)
    }
}
ORDER BY ?companyName

results.csv