ticket #120080 2

ticket #120080 2

PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#>
PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#>
PREFIX aqd: <http://rdfdata.eionet.europa.eu/airquality/ontology/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX aq: <http://reference.eionet.europa.eu/aq/ontology/>
PREFIX obligations: <http://rod.eionet.europa.eu/obligations/>

SELECT DISTINCT
  MAX(?timePosition) AS ?timePosition
  ?samplingPoint
WHERE 
  {
      {
        SELECT DISTINCT 
          ?samplingPoint_inner AS ?samplingPointOriginal
          if(bound(?samplingPointType_inner),  ?samplingPoint_inner, URI(concat('http://reference.eionet.europa.eu/aq/',?samplingPoint_inner))) AS ?samplingPoint
        WHERE {
          GRAPH ?file {
            ?observation_inner a aqd:OM_Observation .
            ?observation_inner aqd:parameter ?parameter_inner .
            ?parameter_inner aqd:value ?samplingPoint_inner .
          }
        OPTIONAL { ?samplingPoint_inner a ?samplingPointType_inner . }
        }
      }
      GRAPH ?file {
        ?observation a aqd:OM_Observation .
        ?observation aqd:resultTime ?resultTime . 
        ?resultTime aqd:timePosition ?timePosition .
        ?observation aqd:parameter ?parameter .
        ?parameter aqd:value ?samplingPointOriginal .
      }

      ?samplingPoint a aq:SamplingPoint .
      ?file cr:xmlSchema ?xmlschema .
   }