Indicator specifications and data/externaldata

PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf-syntax: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX Specification: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX Assessment: <http://www.eea.europa.eu/portal_types/Assessment#>
PREFIX AssessmentPart: <http://www.eea.europa.eu/portal_types/AssessmentPart#>
PREFIX EEAFigure: <http://www.eea.europa.eu/portal_types/EEAFigure#>
PREFIX Data: <http://www.eea.europa.eu/portal_types/Data#>
PREFIX ExternalDataSpec: <http://www.eea.europa.eu/portal_types/ExternalDataSpec#>
PREFIX DavizVisualization: <http://www.eea.europa.eu/portal_types/DavizVisualization#>


SELECT DISTINCT
?code as ?indicatorCode
?specification
?specificationUrl
?data
?dataUrl
IF (?dataType = Data:Data, 'data', 'externalData') as ?dataType

IF (bif:isnull(?data_owner), ?exdata_provider_url, ?data_owner) as ?dataProvider 

?reportingObligations as ?reportingObligation


bif:either (bif:isnull(?reportingObligations),'',iri(fn:concat('http://rod.eionet.europa.eu/obligations/', ?reportingObligations)))  AS ?reportingObligationUrl

#fn:concat('http://rod.eionet.europa.eu/obligations/', ?reportingObligations) AS ?reportingObligations 

WHERE {
  ?specificationUrl dcterms:title ?specification .
  ?specificationUrl Specification:codes ?code .
  ?specificationUrl rdf-syntax:type ?type . 
  FILTER (?type = Specification:Specification)
  OPTIONAL { ?specificationUrl dcterms:isReplacedBy ?isReplacedBy . }
  OPTIONAL { ?specificationUrl Specification:manager_user_id ?s_manager_user_id . }
  FILTER (!bound(?isReplacedBy))

  ?specificationUrl Specification:relatedItems ?dataUrl .
  OPTIONAL { ?dataUrl dcterms:title ?data } 
  OPTIONAL { ?dataUrl rdf-syntax:type ?dataType } 
  FILTER (?dataType in (ExternalDataSpec:ExternalDataSpec, Data:Data))
  OPTIONAL { ?dataUrl  ExternalDataSpec:provider_url ?exdata_provider_url }
  OPTIONAL { ?dataUrl  Data:dataOwner ?data_owner } .
  OPTIONAL { ?dataUrl  Data:reportingObligations ?reportingObligations } .

} 
ORDER BY ?ind_code