4DIfBOqtkb2GRlVy3Z3sTQOgFuab4/2kxUKxpl3kuOMT/3TIwulTaDlolt9/4q0tCFyD6BlihvHGycojpAolezlaEabPyu6GqKp7Pq9VN5fKOPkexKS/wgC+E6FOkWcumexfs8dEx6/PhAjZl2PPERDTyykiSQWUCh14wIO1+9s+NgJxui5MKSsuvG65rEwYw0ysW2izjtq0WXQhBCYplJUY0cQONjRC2oiX7nNfBvUBTgDwCnjrX9R5MSZkILt4p6KUs+sAeUZx22twbsyQGYPRP1bOCm01uCyWwIcS/A2WeD967JjkFBPDe5eu6Fx/NlHM7i8vnM/4304M5NrHI6bWVyDSuf+ZxiB/YGuael28nrdW/3vdOpr5OuGrrW6HHrBkMTjtc2MNa8iV9fea1BVyx0DQKxO8m8VMxmi7edCERr4Hwg8mDB+Dn1B7gyIrb9bEgbM09iJdiN13QwrjSUpLqFQ83aa/0TtWhc1yOhzFpxdBNmG0mWHqN/gx7xYG2QPCbDcecXAdT6S2vVRS1Gh6N5C4ps/ylAtZIdvPMVpsp8Hv3jlMc2HBRHPdir0dXFrus3cU/ofuhpCTs637TIUR2YqCkD6a4pPPuv9JGtl+hepRepOK4UrDC0oQzC1w/DW0s2APK1TrrFH2cDdfLk9U24yZMUR1swm+MAUVJiFiyInTXwfJ4Stp8Zk9eia3ckzpaJJXeqok7don5mjI/uuPrISo2J8rjM1INn8QIHygnYMfPn0IkhL/aRWkNiCMIbkmeuOuRPL5E8f9+z9JkitJ5r6K7fvpoTmEl9VWkbGT/FyyL65UJ8IFAJiGiCTdZxLev+DBbQru9SUrLIZoN8W76FcGenguJ7ieobQnlbBOuJsn2UbPYnnJ32//R7hjLIT4h7D6+TD7NiSUaXe/gqeyKeHk1NSWFjfA+ogfGyYZBMrya0HMy91yoi7Sr9/N1uzQgeizDNm6c3GNZdVHO6zhdAcy0iEeX0pawDwp60q/Zw6jenZtp/51pooZP5/NOQRbDHNOYeiqqRvkKGROCnetYSs5CRnNDCWVCj/eT52WtpTnRIguJhbpHgbGWztRi5UGWa2tHPsASKRLGSsEb27zAe7gt2Bl+6RmpLZaBR+SNmeO1tp2vpgCEkkBkwhj5lVM8uq227WfMQDNw0fGbbGC/x4X0FAjSje1Mw7hYns4py+7uMN0oUeuHk9/7Cy+XdKfsDaJS3iFTZMqLY6fLIXvCU+teNks2qb2SrTdQtLsjIoFrIz+Vst6d3GT0MI+KnavDwxseA3m/oMBjstD9M+M2dW33NBMgir9Fx+Oq/SL3qFgU/vMoE4BooUg1iAhwV38KYq919db88rZ7YGfVzXjOFxLuagczjIqqcs=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100