ZfZDQ208IYK9F0/C9n652hLHDEw7iCrN8B3ZiIOe7IUVM9eb7bBvByVLMzcGoR2983mQcqO69AkSsR5fBwDqAZKqGPEZDwdyEuXwtxfdDkV58UuOQY1TUA0QX+BpsNKMusYAJWjVyH9xef9wTDVOqyBJI7XGm1bampSF5R1NRwLSLBykJQQFNgJYSyOlkB2RVhSZwuIp+JSwVQFlKDA8LHH8DxsfmyxDo7fzvBQvVHL+qt0zMcOijAzuRONg2cg5gLkMR92umc8HY5zz151/A+2Kd6lVwvVB1LgzcucI61ed2NJbc37WM17mxpUbHRrs6ATJTrR84XRYZdkhIypKmJt9Ov0dudHPPUekGj/jSdIlwfJby/yzohoqtlBsGPYkZMgi9WDowhJwn0JAuIKOV4xGCd+0u5toggHFw9n+wPyh1P3SSGoIl3sWFFGuDcC/f1OrRyzPMJarZ4Osf6fNxDO4g70GoC+UPnYWI/Y8JfdcABEV6LkojxzJWvrNBa+C+3ATC+xHUlyU8PWY9FjR6xlbr3cQt/dtbg5C+SmjMNcetGjwIOW8rqCVJPSZUOAM69O41e7oIkCtt6gYrC1Rujl7CCwP6jMoN8loWdCN7sEvlavMmbRnw4Uwef+1IYxxjXW1iLzDm8P6ehW+VFHoOXvHIxmZCvhX5crQ+Jiso3W7Kn/WLg5MsiguIwykeniMrb+xaxetDZAJkcHcT7Kh6byzKaRKUUl30mS2b/iDUjMmNxPINmJbvaW1wMURnoA9Wz2xzOd7BBPWs/TZRxjxxsUGks3JQu0JsO0oDfeQUEWgvgre1O3NYnv3XLuSWyFRup/zB2wZb/uYR1DBoMf9PjELskCpF2SmRwvYqDORHkgKx4GNXTM2s+Hdyj363YbUhtWoj3AuROPPdnATnL0zZuUcxVrCp0BlXNRfealpxbI9VHUSM0mzFICkaGBo5lH97KLmvAemWxCPnfwzfTWBWtzwJF9d3y1w6EJMOiqrjIX66harO63tOg3S1cZbzCT9QaK+toxvr7Hbcg4Fm5Wz39IeHQhvsGiqp9rt0TAWsspVnhzi6vSnL41jIuuMTjusilc/jYPQ/RpQbYPAUKZ7N73hQ8lvN6u1zhxhhfO51zNB8cO7Jh4VSbQLbFq0qtGCo01E7v10p9DM1SHyeOaCLNRBqTqbSR+zOlcCeExrI8GZCOczpTaqtOe7hRzi7hXrKXzYJ9yfdKaCsrctTrgEcDeATsp5TVfXd+bIET7ZkaTdZzRLKAUmYT8P3M0Apn6SeFIDL6Q04TiQLq86p54o4fWumhl4SvJJWD5mefy3pLKKOfR0dvxuPSA02raWWBf1+EwQsX+eevjU/ZaDGWPvpHNEAgiMhLPMtecQMzU=
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