SELECT 
        st_astext(ST_PointOnSurface(ST_Buffer(v.geom,0.1))) as geom, 
        vt.libelle||' '||v.voielib as titre,  
        c.cimetierelib||' '||zt.libelle||' '||z.zonelib||' ('||z.zone||')'||vt.libelle||' '||v.voielib||' ('||v.voie||')' as description, 
        z.zone as idx
        FROM &DB_PREFIXEvoie v
            JOIN &DB_PREFIXEvoie_type vt 
                ON vt.voie_type = v.voietype
            JOIN &DB_PREFIXEzone z
                ON z.zone=v.zone 
            JOIN &DB_PREFIXEcimetiere c 
                ON c.cimetiere=z.cimetiere 
            JOIN &DB_PREFIXEzone_type zt 
                ON zt.zone_type=z.zonetype 
        WHERE 
            v.zone IN (SELECT distinct zone FROM &DB_PREFIXEvoie WHERE voie IN (&idx))