PB : select pgiArticle.* , prx.prix_mensu_vehi, cot.prix_mensuel, cot.apport, cot.duree from pgiArticle , vivafi_cotation as cot, vivafi_prix_mensuel as prx where pgiArticle.ref = cot.ref_vehicule and cot.ref_vehicule = prx.reference_vehi and cot.duree = '60' and cot.apport = 0 and cot.prix_mensuel < 900 and ( pgiArticle.amp;fieldspec1 = 'Soul EV' ) and Flag_censure=1 order by position, fr_designation : 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 ';fieldspec1 = 'Soul EV' ) and Flag_censure=1 order by position, fr_designation' at line 2