BODS RDF - Outstanding mortgages for a UBO's companies

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 ?directControl ?directControlShares
WHERE {
    bodsr:openownership-register-10981547892767219580 bods:ownsOrControls+ ?company .
    ?company foaf:name ?companyName .
    ?company cht:NumMortOutstanding ?mortgages .
    FILTER (?mortgages > 0)

    OPTIONAL {
        ?ctrlStatement bods:hasInterestedParty bodsr:openownership-register-10981547892767219580 .
        ?ctrlStatement bods:hasSubject ?company .
        ?ctrlStatement bods:statesInterest ?interest .
        ?interest bods:sharesMin ?directControlShares .
    }

    BIND (IF(BOUND(?ctrlStatement), "true", "false") AS ?directControl)
}

results.csv