Résultats de votre recherche Voir toutes les offres

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-05-05" and s.DATE_F >= "2026-05-05" and s.TYPE="RECHERCHE" and FIND_IN_SET(a.Ville,'Casablanca') and (upper(CONVERT(o.Titre USING utf8)) LIKE upper('%majorel%') OR upper(CONVERT(o.Description USING utf8)) LIKE upper('%majorel%')OR upper(CONVERT(o.Profile USING utf8)) LIKE upper('%majorel%') OR upper(CONVERT(o.Avantages USING utf8)) LIKE upper('%majorel%')OR upper(a.Ville) LIKE upper('%majorel%') OR upper(a.Adresse) LIKE upper('%majorel%') OR upper(c.LIEN) LIKE upper('%majorel%') OR upper(a.Nom) LIKE upper('%majorel%')) and o.archive!="1" group by o.ID_centre ORDER by rand()) as R on OO.ID=R.ID