Mineral waste from construction and demolition, waste treatment

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>

SELECT 
year(?date ) as ?date
?geo
?wst_oper
?obsValue as ?absoluteObsValue
round((?obsValue/?rtr)*1000.0)/10.0 as ?obsValue
#?rtr
{
  SELECT DISTINCT
    ?date 
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?geo
    if(contains(?wst_oper_label, '('), STRBEFORE(?wst_oper_label, '('), ?wst_oper_label) as ?tmp
    lcase(REPLACE(REPLACE(?tmp, 'Recovery - ','' ), 'Disposal - ','')) as ?wst_oper

    sum(?obsValue) as ?obsValue
    sum(?obsValue_tot) as ?rtr
  WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wastrt.rdf.gz> { 
    {
      _:env_wastrt sdmx-dimension:timePeriod ?date .
      _:env_wastrt property:hazard hazard:HAZ_NHAZ .
      _:env_wastrt property:waste waste:W121 .
      _:env_wastrt sdmx-dimension:refArea ?geo .
      _:env_wastrt property:wst_oper ?wst_oper .
      FILTER (?wst_oper in (wst_oper:DSP_L_OTH, wst_oper:DSP_I, 
                            wst_oper:RCV_E, wst_oper:RCV_R, wst_oper:RCV_B))
      _:env_wastrt sdmx-attribute:unitMeasure unit:T .
      _:env_wastrt sdmx-measure:obsValue ?obsValue .

      _:env_wastrt_tot sdmx-dimension:timePeriod ?date .
      _:env_wastrt_tot property:hazard hazard:HAZ_NHAZ .
      _:env_wastrt_tot property:waste waste:W121 .
      _:env_wastrt_tot sdmx-dimension:refArea ?geo .
      _:env_wastrt_tot property:wst_oper wst_oper:TRT .
      _:env_wastrt_tot sdmx-attribute:unitMeasure unit:T .
      _:env_wastrt_tot sdmx-measure:obsValue ?obsValue_tot .
    }
  }}
  ?geo rdfs:label  ?ugeo .
  ?wst_oper rdfs:label ?wst_oper_label .
  #FILTER (?geo in (geo:EU28))
  FILTER (year(?date) = 2016) 
 }
}
GROUP BY ?date ?geo ?wst_oper ?obsValue ?rtr
HAVING (?rtr > 0)
ORDER BY ?ugeo