CO2-emission intensity from electricity generation in EU28

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX unfccc_geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>

SELECT 
?date
'European Union (28 countries)' as ?ugeo
'Electricity generation' as ?type
round((?den/?nom)*10000)/10.0  as ?obsValue
{{

SELECT DISTINCT
year(xsd:date(?date)) as ?date
#?geo
( sum(?nrg_105a_101121) + sum(?nrg_105a_101122) + sum(?nrg_105a_101102 ) + sum(?nrg_105a_101200) ) / 86 as ?nom

( ( ( sum(?nrg_110a_6000)/ ( sum(?nrg_110a_5200) + sum(?nrg_110a_6000) + sum(?nrg_106a) ) ) * sum(?unfccc_crf) /1000 ) + ( ( ( sum(?nrg_110a_6000)/ ( sum(?nrg_110a_5200) + sum(?nrg_110a_6000) + sum(?nrg_106a) ) ) * sum(?unfccc_crf) / sum(?nrg_105a_101121) ) * sum(?nrg_105a_101122) /1000 ) ) as ?den
WHERE {
  {
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
      FILTER (?geo in (unfccc_geo:EUA))
       _:unfccc_crf clrtap_nec_unfccc:year ?date .
      FILTER (?date != '1985-1987')
      {
        _:unfccc_crf clrtap_nec_unfccc:unit 'Gg' .
        _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'CO2' .         
        _:unfccc_crf clrtap_nec_unfccc:sector_code sector:1.A.1.a . 
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      }
    }
   } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz>
    {
      _:nrg_105a sdmx-dimension:timePeriod ?date . 
      _:nrg_105a sdmx-dimension:refArea geo:EU28 . 
      _:nrg_105a property:product product:6000 .
      _:nrg_105a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_105a sdmx-measure:obsValue ?nrg_105a .
      {
        _:nrg_105a property:indic_nrg indic_nrg:B_101121 .
        _:nrg_105a sdmx-measure:obsValue ?nrg_105a_101121 .
      } UNION {      
        _:nrg_105a property:indic_nrg indic_nrg:B_101122 .
        _:nrg_105a sdmx-measure:obsValue ?nrg_105a_101122 .
      } UNION {      
        _:nrg_105a property:indic_nrg indic_nrg:B_101102 .
        _:nrg_105a sdmx-measure:obsValue ?nrg_105a_101102 .
      } UNION {      
        _:nrg_105a property:indic_nrg indic_nrg:B_101200 .
        _:nrg_105a sdmx-measure:obsValue ?nrg_105a_101200 .
      }
     }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_106a.rdf.gz>
    {
      _:nrg_106a sdmx-dimension:timePeriod ?date . 
      _:nrg_106a property:indic_nrg indic_nrg:B_101109 .
      _:nrg_106a sdmx-dimension:refArea geo:EU28 . 
      _:nrg_106a property:product product:5200 .
      _:nrg_106a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_106a sdmx-measure:obsValue ?nrg_106a .
     }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_110a.rdf.gz>
    {
      _:nrg_110a sdmx-dimension:timePeriod ?date .
      _:nrg_110a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_110a sdmx-dimension:refArea geo:EU28 .
      _:nrg_110a property:indic_nrg indic_nrg:B_101121 .
      {
        _:nrg_110a property:product product:6000 .
        _:nrg_110a sdmx-measure:obsValue ?nrg_110a_6000 .
      } UNION {      
        _:nrg_110a property:product product:5200 .
        _:nrg_110a sdmx-measure:obsValue ?nrg_110a_5200 .
      }
    } 
  }
  FILTER (year(xsd:date(?date)) >= 1990)
}
GROUP BY year(xsd:date(?date))
}}
ORDER BY ?date