themes Jose

gistfile1.txt

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX data: <http://www.eea.europa.eu/portal_types/Data#>
PREFIX schema: <http://schema.org/>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT
  ?data
  #count(?themes) AS ?count_themes
  ?productID
  ?identifier
  sql:GROUP_CONCAT_DISTINCT(?themes, ' | ') as ?themes
WHERE {
   ?data a data:Data .
   ?data rdfs:label ?dataLabel .
   ?data data:themes ?themes .
   ?data schema:productID ?productID .
   ?data dcterms:identifier ?identifier .
}
ORDER BY ?data