Cereals Excluding Beer Total - Livestock and Fish Primary Equivalent dataset

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 faostat: <http://reference.eionet.europa.eu/faostat/schema/>


SELECT
?date as ?year
sql:GROUP_CONCAT(?item, '') as ?item
(round(sum(?foodvalue)/sum(?popvalue)*10))/10.0 as ?capita
(round(( sum(?foodvalue)/sum(?popvalue) ) / (sum(?foodvalue_idx)/sum(?popvalue_idx) ) *1000))/10.0 as ?index
sum(?foodvalue) as ?foodvalue
sum(?popvalue) as ?popvalue

WHERE {
    {
   GRAPH <http://r.eionet.europa.eu/rdfdumps/faostat/foodsupply_crops_e.rdf.gz> {
   {
     _:foodsupply_crop_e sdmx-dimension:refArea 5706 .
     _:foodsupply_crop_e faostat:item_code 2905 . 
     _:foodsupply_crop_e faostat:item ?item .
     _:foodsupply_crop_e faostat:element_code 641 .
     _:foodsupply_crop_e sdmx-dimension:timePeriod ?date . 
     FILTER (?date >= 1995)
     _:foodsupply_crop_e faostat:unit 'tonnes' . 
     _:foodsupply_crop_e sdmx-measure:obsValue ?foodvalue .

     _:foodsupply_crop_e_idx sdmx-dimension:refArea 5706 .
     _:foodsupply_crop_e_idx faostat:item_code 2905 . 
     _:foodsupply_crop_e_idx faostat:element_code 641 .
     _:foodsupply_crop_e_idx sdmx-dimension:timePeriod 1995 . 
     _:foodsupply_crop_e_idx faostat:unit 'tonnes' . 
     _:foodsupply_crop_e_idx sdmx-measure:obsValue ?foodvalue_idx .
   }}
    } UNION {
    GRAPH <http://r.eionet.europa.eu/rdfdumps/faostat/population_e.rdf.gz> {
     _:population_e sdmx-dimension:refArea 5706 .
     _:population_e faostat:element_code 511 .
     _:population_e sdmx-dimension:timePeriod ?date . 
     FILTER (?date >= 1995)
     _:population_e sdmx-measure:obsValue ?popvalue .
     _:population_e_idx sdmx-dimension:refArea 5706 .
     _:population_e_idx faostat:element_code 511 .
     _:population_e_idx sdmx-dimension:timePeriod 1995 . 
     _:population_e_idx sdmx-measure:obsValue ?popvalue_idx .
    }
  }
}
GROUP BY ?date
HAVING sum(?foodvalue) > 0
ORDER BY ?date