SELECT * from offres AS OO JOIN (SELECT MAX(o.ID) as ID from offres as o INNER JOIN sponsorises as s
on o.ID_centre = s.ID_CENTRE
INNER JOIN centres as c
on o.ID_centre=c.ID_SESSION
INNER JOIN adresse_ca as a
on o.Site=a.ID
where s.DATE_D<= "2026-08-27" and s.DATE_F >= "2026-08-27" and s.TYPE="RECHERCHE"
and FIND_IN_SET(a.Ville,'Kenitra')
and o.archive!="1" group by o.ID_centre ORDER by rand()) as R on OO.ID=R.ID
Offre de la semaine | Emission | Kenitra
30-07-2026 | Emission | Kenitra
Vos principales missions :
Accompagner les clients dans le choix de la solution d'assurance automobile la mieux adaptée à leurs besoins.
Élaborer des devis sur mesure et assurer un...