LAYER
        NAME "species_eea"
        TYPE POLYGON
        #PROCESSING "CLOSE_CONNECTION=DEFER"
        CONNECTIONTYPE POSTGIS
        CONNECTION "host=127.0.0.1 dbname=xxx user=xxx password=xxx port=5432"
        DATA "geom FROM (
            SELECT
                eea.biogeo, eea.cnt_biogeo, eea.area, eea.len, eea.gid, eea.geom,
                co.name, sp_risk.risk
            FROM
                eea
            JOIN
                country co ON co.id = eea.country_id
            LEFT JOIN (
                SELECT
                    sn.name, ri.name as risk, sp_eea.eea_id
                FROM
                    species_name sn
                JOIN
                    language lang ON lang.id = sn.language_id
                JOIN
                    species_name_species sns ON sns.species_name_id = sn.id
                JOIN
                    species sp ON sns.species_id = sp.id
                JOIN
                    taxo_group taxo ON sp.group_id = taxo.id
                JOIN
                    species_eea sp_eea ON sp_eea.species_id = sp.id
                JOIN
                    risk ri ON ri.id = sp_eea.risk_id
                WHERE
                    sp.id=%SPID% AND lang.iso_code='la' AND sn.is_synonym=false
            ) AS sp_risk ON sp_risk.eea_id = eea.gid
        ) as q USING UNIQUE gid USING srid=3857"
        STATUS ON

        METADATA
            "wms_title" "species_eea"
        END

        PROJECTION
            "init=epsg:3857"
        END
    END