QLHpoeCyDQX4PkYeLW+qyMQ93A2ULlJ/E7aspg4/KR8wNGgBGWNbqCvnnqNmTHtFVxji0iY5PklvZiIIHlRdqKnXfpqtZxeczGLJqgn5GmhscNgxZ+AbTdjRPLoHLeHkDq+FJ7G2/AdqSQcqIs6ZZ0R/CkYLwR8rQdoVE9C7YIA/UBigVs3TaS44K09zP3lVABEKbg+CNaq5+8vUlvt4xLxMwmxv6zSkizrYmgE4KGFwEi/lI3S57oqyx4Fc2/YMgw/ewE16YCHfbynbzGxBbhEVMOvF1XOvOYqNRuUH22d/BgLM62ed8dKieS4k/V6zw2b1ZkkxxrAbfLtQhXhqilxLqOo34AbJMvm5h7QvDBl0S3SpCV724rWQ15lD3R1autnpt4gxufxf9xJ8qTN8jI3O+aj5d35jE23470GuenqWuuftWOS6muOWRO8AbPVjiwS9PFYLJJQn87bqng2SE9S5alxYwsOJPjoLl0RC6OfPLS06VfkuePS+p8DfviRDEiX0poNr34kGA4sRnxIMe28Pn1KvlC8tsWTk4W2oMRC9hIvahxrL5FyTxDRa2Z6W5w/AXq8SXH+BEJQHQvtXDpyOyoFsUN6sXfXP1fLrgMt0oL5sDwq5F9LLuVFmq1wJBll9VI5hxeNT1ENaJAJliiRH1XtZQ2z09YYy/o2fj9UC6tTVzej910vn+X+JC2fOMtuFvNxI5UneMhSjRigQWTw+9WC4aYCBJy2V+t8Wp/O9zdiHOtkiW4jNcApKLVbdiTap6YbkvttX3JCBMjoxo7Ox4S2+aNjP2yHrhAXCA6L1WdFcQmy978ZsVRbawaXZWdl8PDGnnULrzFwUWbhINVKron93LxvTLEU4uEnbpD9jz2YRVO7odO5Rscv8NYbhTjVGur0H4gbH9zBb3xZ7gyrDJ4luGv3w+6g59SYUO+qWf6jWBNJ4cQlL8KS8ETwteu5T3U5xofNfBKlzognYdIZzGmfjC/7qsPsyMaIxaxhFRTSCfTs2B/2/XLxKgcFagwAkQYoz1R49UIjuFe5ZPJ9dCUrLO04b9Sx50F5HDtda81l+jrnEospxsdk4+csl7XpCjRQk2ROaCzVkKDhmP4qwy+BiCkMalqAmOs8v3R07dbbAbqBnWsHd1FZzt+bfMtGBkq+PKodse22FcFwgwMdYiPr+nhXX+nxyBoytkBm8BS2C4rfvWlsqR9fxDJCLNS1fxuMG25iN82j4yn+40MciHsWWWmZj4PZiTm1vw6iupAExZ9UNRDRtsVTeXAT4/3F03+wx4ghOPKC+1Ae74purnoUwT7rOJNKQSaYjlvsdPAUxjK3CkVr0PAmY7knBtDlsYLrDZPz6KHaeKKSML3WJQvr34OQzD5tCSDY=
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