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 (GROUP_CONCAT(?sicText) AS ?sicInfo)
WHERE {
    ?parent bods:ownsOrControls+ ?company .
    ?parent bods:ownsOrControls+ bodsr:openownership-register-14662912447190623115 .
    ?company foaf:name ?companyName .
    ?company cht:SicText ?sicText .
    FILTER (!sameTerm(?company, bodsr:openownership-register-14662912447190623115))
}
GROUP BY ?companyName
ORDER BY ?companyName

results.csv