gistfile1.txt

PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#>
PREFIX aq: <http://rdfdata.eionet.europa.eu/airquality/ontology/>
PREFIX aqr: <http://reference.eionet.europa.eu/aq/ontology/>
PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#>
PREFIX obligations: <http://rod.eionet.europa.eu/obligations/>
PREFIX aqdd: <http://dd.eionet.europa.eu/property/>

SELECT DISTINCT

#?XMLURI
?Country as ?CountryOrTerritory 
year(xsd:date(?endOfPeriod)) AS ?ReportingYear 
?PlanCode 
?Namespace 
?PlanId 
?VersionId 
?Name 
?FirstExceedanceYear 
?AdoptionDate 
?Status 
?TimeTable 
?ReferenceAQPlan 
?ReferenceImplementation 
?Pollutant 
?ProtectionTarget 
?PublicationTitle 
?PublicationDate 
?PublicationAuthor 
?PublicationDescription 
?Publisher
?PublicationWeblink 
?Organisation 
?IndividualName 
?Email 
?Phone 
?Website 
?Address 
sql:GROUP_CONCAT_DISTINCT(?Comment,' ') AS ?Comment
?envelope

WHERE {{
  GRAPH ?source {
    ?XMLURI a aq:AQD_Plan .
    ?XMLURI aq:inspireId ?inspireURI .
    ?XMLURI aq:code ?PlanCode .
    ?XMLURI aq:name ?Name .
    ?XMLURI aq:competentAuthority ?compAuthorityURI .
    ?XMLURI aq:firstExceedanceYear ?firstexcURI .
    ?XMLURI aq:adoptionDate ?adoptionURI .
    ?XMLURI aq:timeTable ?TimeTable .
    ?XMLURI aq:referenceAQPlan ?ReferenceAQPlan .
    ?XMLURI aq:referenceImplementation ?ReferenceImplementation .
    ?XMLURI aq:pollutants ?pollURI .
    ?XMLURI aq:publication ?publURI .
    ?XMLURI aq:status ?StatusURI .
  }
  ?source dcterms:isPartOf ?envelope .
  ?envelope rod:released ?released .
  ?envelope rod:locality ?locality .
  ?envelope rod:obligation ?obliURI .
  ?envelope rod:endOfPeriod ?endOfPeriod .

  OPTIONAL{?XMLURI aq:comment ?Comment} .

FILTER (?envelope = <http://cdr.eionet.europa.eu/it/eu/aqd/h/envxx9uaa>)
#http://cdr.eionet.europa.eu/it/eu/aqd/h/envxx9uaa
#http://cdr.eionet.europa.eu/fr/eu/aqd/h/envxfjxhq
}}