query_11.txt

Id, subtype and date of the formalized contracts with the supplier MULTITEC

PREFIX pproc: <http://contsem.unizar.es/def/sector-publico/pproc#>
PREFIX s: <http://schema.org/>
PREFIX gr: <http://purl.org/goodrelations/v1#>
PREFIX pc: <http://purl.org/procurement/public-contracts#>
SELECT distinct ?uriCont ?formalizedDate ?type 
WHERE {
  ?uriCont a <http://contsem.unizar.es/def/sector-publico/pproc#Contract>;
  pc:tender ?tender ;
  a ?type .
  ?tender pproc:formalizedDate ?formalizedDate ;
  pproc:supplier ?supplier .
  ?supplier s:name ?name .
  FILTER (regex(?name, "URBANCO", "i"))
}
ORDER BY ?formalizedDate