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

results.csv