indicator_ancillaries_01

indicator_ancillaries_01

PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX Assessment: <http://www.eea.europa.eu/portal_types/Assessment#>
PREFIX Specification: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX PolicyQuestion: <http://www.eea.europa.eu/portal_types/PolicyQuestion#>
PREFIX ontologies: <http://www.eea.europa.eu/ontologies.rdf#>
PREFIX indicators_workflow: <http://www.eea.europa.eu/portal_workflow/indicators_workflow/states/>

SELECT distinct
?specification
?assessment
sql:GROUP_CONCAT_DISTINCT(?codes, ' | ') as ?codes
?label
sql:GROUP_CONCAT_DISTINCT(?policy_question, ' | ') as ?policy_questions
?key_message
?policy_context_description
?policy_context_targets

WHERE {
  ?assessment rdf:type Assessment:Assessment .
  OPTIONAL {?assessment dcterms:isReplacedBy ?isReplacedBy}
  FILTER (!bound(?isReplacedBy))
  ?assessment dcterms:abstract ?key_message .
  ?assessment rdfs:label ?label .
  ?assessment dcterms:hasPart ?assessmentPart .
  ?assessment dcterms:expires "None"@en .

  ?assessment ontologies:hasWorkflowState indicators_workflow:published .

  ?specification dcterms:hasPart ?assessment  .
  ?specification Specification:codes ?codes .

  ?specification Specification:policy_context_description ?policy_context_description .
  OPTIONAL { ?specification Specification:policy_context_targets ?policy_context_targets }.
 
  OPTIONAL { ?assessmentPart rdfs:label ?policy_question } .

  #FILTER (?codes in ('SEBI019')

} 
ORDER BY ?codes
LIMIT 10000