entities-controlling-companies-with-public-contracts.sparql

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX bodsr: <http://bods.openownership.org/resource/>
PREFIX bodsrisk: <http://bods.openownership.org/risk/>

SELECT DISTINCT ?target ?type
WHERE {
    ?target bods:ownsOrControls+ ?company .
    ?target rdf:type ?type .
    ?company bodsrisk:awardedPublicContract ?c .
    FILTER(STRSTARTS(STR(?target), STR(bodsr:)))
    FILTER(SAMETERM(?type, bods:Entity) || SAMETERM(?type, bods:Person))
}