Transport 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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT 
year(?date) as ?date

?road_gasoline
?biogasoline
?road_diesel
?biodiesel
?natural_gas
?lpg
?electricity_road
?electricity_rail
?rail_diesel_gas_oil
?rail_residual_fuel_oil
?aviation_gasoline
?aviation_kerosene
?ship_diesel_gas_oil
?ship_residual_fuel_oil
?ship_gasoline 
?other_liquid_biofuels

#(?road_gasoline + ?road_diesel + ?natural_gas + ?lpg + ?rail_diesel_gas_oil + ?rail_residual_fuel_oil + ?aviation_gasoline + ?aviation_kerosene + ?ship_diesel_gas_oil + ?ship_residual_fuel_oil + ?ship_gasoline  + ?other_liquid_biofuels) as ?oil_derived_fuels

(?aviation_gasoline + ?ship_residual_fuel_oil + ?diesel + ?aviation_kerosene + ?lpg + ?gasoline) as ?oil_derived_fuels


(?gasoline + ?biogasoline + ?diesel + ?biodiesel_blended + ?natural_gas + ?lpg + ?electricity_road + ?electricity_rail + ?rail_diesel_gas_oil + ?rail_residual_fuel_oil + ?aviation_gasoline + ?aviation_kerosene + ?ship_diesel_gas_oil + ?ship_residual_fuel_oil + ?ship_gasoline  + ?other_liquid_biofuels) as ?total

round(17359275.323 *0.3) as ?annotation_line
{{

SELECT DISTINCT
  ?date
  sum(?road_gasoline) as ?road_gasoline
  sum(?biogasoline) as ?biogasoline
  sum(?road_diesel) as ?road_diesel
  sum(?biodiesel) as ?biodiesel
  sum(?natural_gas) as ?natural_gas
  sum(?lpg) as ?lpg
  sum(?electricity_road) as ?electricity_road
  sum(?electricity_rail) as ?electricity_rail
  sum(?rail_diesel_gas_oil) as ?rail_diesel_gas_oil
  sum(?rail_residual_fuel_oil) as ?rail_residual_fuel_oil
  sum(?aviation_gasoline) as ?aviation_gasoline
  sum(?aviation_kerosene) as ?aviation_kerosene
  sum(?ship_diesel_gas_oil) as ?ship_diesel_gas_oil
  sum(?ship_residual_fuel_oil) as ?ship_residual_fuel_oil
  sum(?ship_gasoline) as ?ship_gasoline 
  sum(?other_liquid_biofuels) as ?other_liquid_biofuels

  sum(?diesel) as ?diesel #<- not shown as single value
  sum(?gasoline) as ?gasoline #<- not shown as single value
  sum(?biodiesel_blended) as ?biodiesel_blended #<- not shown as single value
WHERE {
  {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz> 
      {

        _:nrg_bal_c sdmx-dimension:timePeriod ?date .
        _:nrg_bal_c sdmx-attribute:unitMeasure unit:TJ .
        _:nrg_bal_c sdmx-dimension:refArea ?geo .
        {
            _:nrg_bal_c property:nrg_bal ?nrg_bal
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec ?siec .
            FILTER (?siec IN (siec:O4651, siec:O4653)) .
            _:nrg_bal_c sdmx-measure:obsValue ?aviation_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?biogasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E, nrg_bal:FC_TRA_RAIL_E))
            _:nrg_bal_c property:siec siec:R5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?biodiesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?biodiesel_blended .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_ROAD_E .
            _:nrg_bal_c property:siec siec:E7000 .
            _:nrg_bal_c sdmx-measure:obsValue ?electricity_road .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E .
            _:nrg_bal_c property:siec siec:E7000 .
            _:nrg_bal_c sdmx-measure:obsValue ?electricity_rail .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E . 
            _:nrg_bal_c property:siec siec:O4680 .
            _:nrg_bal_c sdmx-measure:obsValue ?rail_residual_fuel_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTMARB, nrg_bal:FC_TRA_DNAVI_E)) . 
            _:nrg_bal_c property:siec siec:O4680 .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_residual_fuel_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal nrg_bal:FC_TRA_RAIL_E.
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?rail_diesel_gas_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTMARB, nrg_bal:FC_TRA_DNAVI_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_diesel_gas_oil .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:FC_TRA_ROAD_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?road_diesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:FC_TRA_ROAD_E, nrg_bal:FC_TRA_DNAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_RAIL_E)) .
            _:nrg_bal_c property:siec siec:O4671XR5220B .
            _:nrg_bal_c sdmx-measure:obsValue ?diesel .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec siec:O4661XR5230B .
            _:nrg_bal_c sdmx-measure:obsValue ?aviation_kerosene.
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:O4630 .
            _:nrg_bal_c sdmx-measure:obsValue ?lpg .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:FC_TRA_ROAD_E))
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?road_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DAVI_E, nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
            FILTER (?nrg_bal IN (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E)) .
            _:nrg_bal_c property:siec siec:O4652XR5210B .
            _:nrg_bal_c sdmx-measure:obsValue ?ship_gasoline .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:G3000 .
            _:nrg_bal_c sdmx-measure:obsValue ?natural_gas .
        } UNION {
            _:nrg_bal_c property:nrg_bal ?nrg_bal .
             FILTER (?nrg_bal in (nrg_bal:INTAVI, nrg_bal:FC_TRA_DAVI_E, 
                     nrg_bal:INTMARB, nrg_bal:FC_TRA_ROAD_E, 
                     nrg_bal:FC_TRA_DNAVI_E))
            _:nrg_bal_c property:siec siec:R5290 .
            _:nrg_bal_c sdmx-measure:obsValue ?other_liquid_biofuels .
        }

      }
   #FILTER (?geo in (geo:EU28, geo:LI, geo:NO, geo:CH, geo:TR, geo:IS))
   FILTER (?geo in (geo:EU28))
   #FILTER (year(?date) in (1990, 2008, 2017))
   }
}


}}
GROUP BY ?date 
ORDER BY ?date