Nationally designated areas by IUCN category and major ecosystem type

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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX schema: <http://reference.eionet.europa.eu/cdda/schema/>
PREFIX eunis-schema: <http://eunis.eea.europa.eu/rdf/schema.rdf#>

SELECT
  ?country
  bif:either(UCASE(?major_ecosystem_type) = 'T', 'Terrestrial ecosystem',
         bif:either(?major_ecosystem_type = 'MT', 'Mixed marine and terrestrial ecosystem',
         bif:either(?major_ecosystem_type = 'M', 'Marine ecosystem',
         'Ecosystem type not available'))) as ?major_ecosystem_type

  bif:either(UCASE(?iucncat) in ('UA', 'NA', 'NOTREPORTED'), 'Not reported', 
          bif:either(UCASE(?iucncat) in ('NOTAPPLICABLE'), 'Not applicable',
          bif:either(UCASE(?iucncat) in ('NOTASSIGNED'), 'Not assigned',
         REPLACE(STR(?iucncat),'A','a')))) as ?iucncat #'IA' -> 'Ia'

  count(?site_code) as ?sites
  sum(?site_area) as ?site_area
  bif:either(strlen(?iucncat) > 3, 2,
  bif:either(?iucncat in ('Ia','Ib') , 0,
  1)) as ?order

WHERE {
GRAPH <http://r.eionet.europa.eu/rdfdumps/cdda/cddasites.rdf.gz> 
  {
    ?sites schema:site_code ?site_code .
    ?sites schema:parent_iso ?parent_iso .
    ?sites schema:site_area ?site_area .
    ?sites schema:iucncat ?iucncat .
    OPTIONAL { ?sites schema:major_ecosystem_type ?major_ecosystem_type } .
  }
  ?eunis_country eunis-schema:iso_3_wcmc ?parent_iso .
  ?eunis_country rdfs:label ?country .

}
GROUP BY ?country ?major_ecosystem_type ?order ?iucncat
ORDER BY ?country ?major_ecosystem_type ?order ?iucncat