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!='V031'
AND prix_loyer_prix_de_cession>=0
AND prix_loyer_prix_de_cession<=0
ORDER BY DIF_PRIX