Fish Seafood (Total) - Livestock and Fish Primary Equivalent dataset

PREFIX tableFile: <http://semantic.eea.europa.eu/project/faostat/2014/foodsupply_livestockfish_e.txt#>
PREFIX poptableFile: <http://semantic.eea.europa.eu/project/faostat/2014/population_e.txt#>

SELECT
?year
'Fish and seafood' as ?item
(round(sum(?foodvalue)/sum(?popvalue)*10))/10.0 as ?capita
#hard coded values for indexing taken from the results of the query
(round(( sum(?foodvalue)/sum(?popvalue) ) / (9804000.0/484619.0 ) *1000))/10.0 as ?index
sum(?foodvalue) as ?foodvalue
sum(?popvalue) as ?popvalue

WHERE {
    {
   GRAPH <http://semantic.eea.europa.eu/project/faostat/2014/foodsupply_livestockfish_e.txt> {
   {
     _:foodsupply_livestockfish_e tableFile:CountryCode ?CountryCode .
     _:foodsupply_livestockfish_e tableFile:ItemCode 2960 . 
     _:foodsupply_livestockfish_e tableFile:ElementGroup 641 . 
     _:foodsupply_livestockfish_e tableFile:ElementCode 641 .
     _:foodsupply_livestockfish_e tableFile:Year ?year . FILTER (?year >1994)
     _:foodsupply_livestockfish_e tableFile:Unit 'tonnes' . 
     _:foodsupply_livestockfish_e tableFile:Value ?foodvalue .
   }}
    } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/faostat/2014/population_e.txt> {
     _:population_e poptableFile:CountryCode ?CountryCode .
     _:population_e poptableFile:ElementGroup 511 .
     _:population_e poptableFile:ElementCode 511 .
     _:population_e poptableFile:Year ?year . FILTER (?year >1994)
     _:population_e poptableFile:Value ?popvalue .
    }
}
FILTER (?CountryCode in (11, 15, 255, 27, 98, 50, 167, 54, 63, 67, 68, 79, 84, 97, 104, 106, 119, 126, 256, 134, 150, 173, 174, 183, 199, 198, 203, 210, 229))
}
GROUP BY ?year
ORDER BY ?year