SELECT 
        .code_ AS code_echelle,
        .lib_  AS lib_echelle,
        
        (((t2.cSurfParcelles/10000)-(t1.cSurfParcelles/10000))/(t1.cSurfParcelles/10000)) * 100 AS evo_bvsm,        
              
        ST_AsGeoJson(.SHAPE) AS geom   
     
     FROM   
     
     LEFT JOIN (
         SELECT 						 	
             .*,
             .cCode            
         FROM 
         LEFT JOIN  
         ON  AND cAnnee = '' AND cType = 1
         
    ) AS t1
     ON .code_ = t1.cCode
     
     LEFT JOIN (
         SELECT 						 	
             .*,			                     
             .cCode            
         FROM                  
         LEFT JOIN  
         ON  AND cAnnee = '' AND cType = 1
         
    ) AS t2
     ON .code_ = t2.cCode   
     
      
       
     GROUP BY .code_      
 Erreur Mysql : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS code_echelle,
        .lib_  AS lib_echelle,
        
        (((t2.cSurfP' at line 2