Trends in total energy intensity, gross domestic product and total energy consumption

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 sdmx-unit: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX indic_na: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_na/> 
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT 
year(?date) as ?date
(round((?obsValue_nrg/?obsValue_nrg_idx)*1000))/10.0 as ?total_energy_consumption
(round((?obsValue_gdp/?obsValue_gdp_idx)*1000))/10.0 as ?gross_domestic_product_at_2005_market_prices
(round(((?obsValue_nrg/(?obsValue_gdp/1000))/(?obsValue_nrg_idx/(?obsValue_gdp_idx/1000)))*1000))/10.0 as ?total_energy_intensity

#GDP Forecast - Annotation Line
bif:either(year(?date) > 2010, 1000000,'') AS ?annotation_line

{{
  SELECT
    ?date
    #?geo
    #?memberOfcode
    #?country
    sum(?obsValue_nrg) as ?obsValue_nrg
    sum(?obsValue_gdp) as ?obsValue_gdp
    sum(?obsValue_nrg_idx) as ?obsValue_nrg_idx
    sum(?obsValue_gdp_idx) as ?obsValue_gdp_idx
  WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> { 
    { 
      _:nrg_100a sdmx-dimension:timePeriod ?date .
      _:nrg_100a property:indic_nrg indic_nrg:B_100900 . 
      _:nrg_100a sdmx-dimension:refArea ?geo . 
      _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE . 
      _:nrg_100a sdmx-measure:obsValue ?obsValue_nrg .

      _:nrg_100a_idx sdmx-dimension:timePeriod ?date_nrg_idx .
      _:nrg_100a_idx property:indic_nrg indic_nrg:B_100900 . 
      _:nrg_100a_idx sdmx-dimension:refArea ?geo . 
      _:nrg_100a_idx sdmx-attribute:unitMeasure unit:KTOE . 
      _:nrg_100a_idx sdmx-measure:obsValue ?obsValue_nrg_idx .
      FILTER (year(?date_nrg_idx) = 1995)
    }}
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz> { 
    {
      _:nama_10_gdp sdmx-dimension:timePeriod ?date .
      _:nama_10_gdp property:na_item na_item:B1G . 
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV05_MEUR . 
      _:nama_10_gdp sdmx-dimension:refArea ?geo . 
      _:nama_10_gdp sdmx-measure:obsValue ?obsValue_gdp .   
 
      _:nama_10_gdp_idx sdmx-dimension:timePeriod ?date_gdp_idx .
      _:nama_10_gdp_idx property:na_item na_item:B1G . 
      _:nama_10_gdp_idx sdmx-attribute:unitMeasure unit:CLV05_MEUR . 
      _:nama_10_gdp_idx sdmx-dimension:refArea ?geo . 
      _:nama_10_gdp_idx sdmx-measure:obsValue ?obsValue_gdp_idx .
      FILTER (year(?date_gdp_idx) = 1995)
    }
   }
   FILTER (year(?date) >= 1995) 
  }
  ?geo skos:prefLabel ?country . 
  ?geo skos:notation ?ugeo . 
  ?eeageo owl:sameAs ?geo . 
  ?eeageo skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> . 
  ?memberOf skos:member ?eeageo . 
  ?memberOf skos:notation ?memberOfcode . 
  FILTER (?memberOfcode = 'EU28')
  }
}}  
GROUP BY ?date 
ORDER BY ?date