SELECT
        ST_AsText(e.geom) as geom,
        e.nature||' '||CASE WHEN e.libre ='Oui' THEN 'Libre' ELSE COALESCE(famille,'') END||'<BR>'||e.numero||COALESCE(' '||complement,'')||' '||vt.libelle||' '||v.voielib||' '||zt.libelle||' '||z.zonelib||'<BR>'||c.cimetierelib as titre,
        e'' as description,
        e.emplacement as idx
        FROM  &DB_PREFIXEemplacement e
            JOIN  &DB_PREFIXEvoie v
                ON v.voie=e.voie
            JOIN  &DB_PREFIXEvoie_type vt
                ON vt.voie_type=v.voietype
            JOIN  &DB_PREFIXEzone z
                ON z.zone=v.zone
            JOIN  &DB_PREFIXEzone_type zt
                ON zt.zone_type=z.zonetype
            JOIN  &DB_PREFIXEcimetiere c
                ON c.cimetiere=z.cimetiere
        WHERE
            emplacement IN (&idx)