find-risks-for-registered-address.sparql

PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX bodsrisk: <http://bods.openownership.org/risk/>

SELECT ?riskEntity ?relationship (GROUP_CONCAT(DISTINCT ?risk;separator=",") as ?risks)
WHERE {
    ?target bodsrisk:registeredAddress/bodsrisk:fullAddress ?fullAddress .
    ?riskEntity bodsrisk:registeredAddress/bodsrisk:fullAddress ?fullAddress .
    ?riskEntity bodsrisk:hasRisk ?risk .
}
GROUP BY ?riskEntity ?relationship