SELECT .code_ AS code_echelle, .lib_ AS lib_echelle, (((t2.cSurfSuf/10000)-(t1.cSurfSuf/10000))/(t1.cSurfSuf/10000)) * 100 AS evo_foncier_forestier, ST_AsGeoJson(.SHAPE) AS geom FROM LEFT JOIN ( SELECT tindserie1.*, .cCode FROM tindserie1 LEFT JOIN ON AND cAnnee = '' ) AS t1 ON .code_ = t1.cCode LEFT JOIN ( SELECT tindserie1.*, .cCode FROM tindserie1 LEFT JOIN ON AND cAnnee = '' ) 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, (((t' at line 2