select *,titre as letitre,options,bio,aff_premium,LETYPE,DOMAINE,id,paysannonceur,langue,affaire.s_activite,datemodif,affaire.date as dddate, societe, mid(commentaire,1,400) as commentaire,tarif,restriction,conditionnement,quantite,marque,mtsclesref,showroom,urlshowroom, essentielles from affaire where affaire.langue='FR' and afficher is true and supprimer is false AND (affaire.escroc is false) and MATCH(affaire.s_activite, affaire.commentaire, affaire.titre) AGAINST ('+corosol*' IN BOOLEAN MODE) order by options, priorite, DATEMODIF desc,id desc limit 70,35