Consumption of food in EU28

PREFIX tableFile: <http://semantic.eea.europa.eu/project/faostat/2016/foodsupply_livestockfish_e.csv#>

SELECT DISTINCT
year(?date) as ?date
?itemCode
?item
?elementCode
bif:either(?elementCode = 674, 'Protein supply quantity', 'Food supply quantity') as ?element
#?element
'kg/capita/yr' as ?unit
#0.375 converts g/capita/day to kg/capita/yr
bif:either(?elementCode = 674, round(sum(xsd:decimal(?value)) *0.365*100)/100.0, sum(xsd:decimal(?value)) ) as ?value

WHERE {
    GRAPH <http://semantic.eea.europa.eu/project/faostat/2016/foodsupply_livestockfish_e.csv> {
    {
      _:foodsupply_livestockfish_e tableFile:countryCode ?countryCode .
      _:foodsupply_livestockfish_e tableFile:country ?country .
      {
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCode .
        FILTER (?itemCode in (2731, 2738, 2741, 2733, 2743, 2732, 
                             2731, 2734, 2761, 2762, 2740, 2763))
        _:foodsupply_livestockfish_e tableFile:item ?item .
 
      } UNION {
        { SELECT 'Meat, other + edible offals' as ?item {} }
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCodeDummy .
        FILTER (?itemCodeDummy in ( 2763, 2735 ))

      } UNION {
        { SELECT 'Other fish and seafood' as ?item {} }
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCodeDummy .
        FILTER (?itemCodeDummy in (2767, 2764, 2766, 2765))
      }
     
      _:foodsupply_livestockfish_e tableFile:elementCode ?elementCode .
      FILTER (?elementCode in (674, 645))

      _:foodsupply_livestockfish_e tableFile:element ?element .
      _:foodsupply_livestockfish_e tableFile:unit ?unit .
      _:foodsupply_livestockfish_e tableFile:date ?date . 
      FILTER (year(?date) in (1995, 2011))
      _:foodsupply_livestockfish_e tableFile:value ?value .
    }
    FILTER (?countryCode = 5706)
  }
}