SES2_indicators_assessment_snapshot

PREFIX dcterms: <http://purl.org/dc/terms/> 
PREFIX rdf-syntax: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX s: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX a: <http://www.eea.europa.eu/portal_types/Assessment#>

SELECT 
sql:group_concat(?themes,' | ') AS ?themes
?codes ?s_id ?s ?dpsir ?typology ?manager_user_id ?a_id ?a ?a_issued ?frequency_of_updates
{{
SELECT DISTINCT
?themes 
?codes
?s_id
?s
?dpsir
?frequency_of_updates
?typology
?manager_user_id
?a_id
?a
xsd:date(?a_issued) as ?a_issued
WHERE {
  ?s s:id ?s_id .
  ?s s:codes ?codes .
  ?s s:themes ?themes .
  ?s rdf-syntax:type ?type FILTER (?type = s:Specification)
  ?s s:dpsir ?dpsir .
  OPTIONAL { ?s s:frequency_of_updates ?frequency_of_updates . }
  OPTIONAL { ?s s:manager_user_id ?manager_user_id . }
  ?s s:typology ?typology .
  OPTIONAL { ?s dcterms:isReplacedBy ?isReplacedBy . }
  FILTER (!bound(?isReplacedBy))

  ?s dcterms:hasPart ?a .
  ?a a:id ?a_id .
  ?a rdf-syntax:type ?a_type FILTER (?a_type = a:Assessment) 
  OPTIONAL { ?a dcterms:issued ?a_issued }
  OPTIONAL { ?a dcterms:isReplacedBy ?a_isReplacedBy . }
  FILTER (!bound(?a_isReplacedBy))
} ORDER BY ?themes
}}
GROUP BY ?codes ?s_id ?s ?dpsir ?typology ?manager_user_id ?a_id ?a ?a_issued ?frequency_of_updates
ORDER BY ?codes