You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS DIF_PRIX FROM annonces_full WHERE type_annonce='' AND ref' at line 1
SELECT *,ABS(prix_loyer_prix_de_cession-) AS DIF_PRIX FROM annonces_full WHERE type_annonce='' AND reference_agence_du_bien!='L397' AND prix_loyer_prix_de_cession>=0 AND prix_loyer_prix_de_cession<=0 ORDER BY DIF_PRIX