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)