SELECT a.* FROM annonces a WHERE numPublicom not Like 'mj_%' AND avec_photo='yes' AND (TRIM(photo1)!='' OR TRIM(photo_bis)!='' ) AND a.valide = 'yes' AND a.paye='yes' AND a.idMarque=397 AND a.idCategorie=2

SELECT a.* FROM annonces a INNER JOIN marques m ON m.id=a.idMarque WHERE numPublicom not Like 'mj_%' AND avec_photo='yes' AND (TRIM(photo1)!='' OR TRIM(photo_bis)!='' ) AND a.valide = 'yes' AND a.paye='yes' AND a.idMarque=397 AND a.idCategorie=2

SELECT a.* FROM annonces a INNER JOIN profils p ON p.id=a.idProfil WHERE numPublicom not Like 'mj_%' AND avec_photo='yes' AND (TRIM(photo1)!='' OR TRIM(photo_bis)!='' ) AND a.valide = 'yes' AND a.paye='yes' AND a.idMarque=397 AND a.idCategorie=2