SELECT offres.id_offre, offres.categ1, offres.date_depot, offres.intitule, offres.lieu, offres.id_client_offre, offres.entreprise, offres.logo, offres.description FROM offres, offres_site WHERE (offres.valide=1) AND (offres.id_offre=offres_site.id_offre) AND (offres_site.id_site=490) AND ((offres.intitule like '%VEFA%') OR (offres.lieu like '%VEFA%') OR (offres.description like '%VEFA%') OR (offres.poste1 like '%VEFA%') OR (offres.poste2 like '%VEFA%') OR (offres.poste3 like '%VEFA%') OR (offres.region1 like '%VEFA%') OR (offres.region2 like '%VEFA%') OR (offres.region3 like '%VEFA%') OR (offres.categ1 like '%VEFA%') OR (offres.categ2 like '%VEFA%') OR (offres.categ3 like '%VEFA%') OR (offres.contrat like '%VEFA%') OR (offres.diplome like '%VEFA%') OR (offres.exp like '%VEFA%') OR (offres.langue1 like '%VEFA%') OR (offres.langue2 like '%VEFA%') OR (offres.langue3 like '%VEFA%')) AND (offres.id_poste1!=0) AND ((DATE_ADD(offres.date_depot, interval 60 DAY)>NOW())=1) GROUP BY offres.id_offre ORDER BY offres.date_depot DESC CarrièreImmo.com, offres d'emploi vendeur VEFA immobilier