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.id_client_offre=480) 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