query.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 bodsr: <http://bods.openownership.org/resource/>
PREFIX cht: <http://www.companieshouse.gov.uk/terms/>

SELECT DISTINCT ?companyName ?mortgages
WHERE {
    ?parent bods:ownsOrControls+ ?company .
    ?parent bods:ownsOrControls+ bodsr:openownership-register-8251351163712700915 .
    ?company foaf:name ?companyName .
    ?company cht:NumMortOutstanding ?mortgages .
    FILTER (?mortgages > 0)
    FILTER (!sameTerm(?company, bodsr:openownership-register-8251351163712700915))
}

results.csv