hYimWWtX4oY0ZIY5AetM2ELDDpl1ARZZTjDhlE1Py6rGiXHE54VyEFMJPcIbwqPUT4iZQynSMNA6K235d3MOc/ULdioz+82ubPcQJvd62+R8Mldf5issK7yyhraZjKyolWuSNYvaaOGYpWqAooScKjm7zOiFdAQIjTebL3mrXCn/QomuuNuFC4bsO8y9zMoa5NJOGSHicbwm6xuUiyN7qpUGv5wRwD6RGRkfalD+lZccn7fa3ZfS+NgGzCwdq295TwbVY/PgxcZm9pDW4HJOA1pf33pUrj70zKmMxsRaM0Q4CreR36P1q1CWbMZvoK3he+TLmKCixvwDydSeT6f9nUH5vQm6EssEqOqj5YdpE14LArN99rkWdWRNJisNwhXMAyEOR6kOAnDUXzMy7Zad56eShyd5dgXU/lG6+ZG995Xw4Ed80NKiWbvtPJsAQSNMatcIsv8fKfOnQT9o1jT/LGnsIthzBNfKKmE5ozcMFSX8tX8SgkhPpnxv7uM3zrA3mZS4iAPDQzcJMN0gNAqbjyKmuMyQqCHTGu1q0zkp+YvT/VRcz+ifvX3arV3Wp6BNwKbTrI2En3Qn/CQdgTkuuCzoD/OC7u/H4S8SLB0/PjcGWAxZMI5M951JLTk07e7dSFtG/RKP5/1ETppL4t5ziZvyoLfItaly6sVVomO5JQPRBOcT6wvANJkMs2JpJG0IDxaQY2yMv1wXKHkJwJN+JRfn3FAleCka3AgNO6UWx/3DvrJfsJNVRtFmJJ95gOqg5KZcDDisvHuBbJkUvzi/cwO1SxonB8mXXM2LCpRPr21HA0xhWCdaX7mQ9RNkOhe4hYDuMSEfitZKw1hDeTUXAIpDvoDRZ/ZOO275MEAioRwIKPQMpEnjVtjpkP2GHNn0M0Mrj6ZP7vB+aZhZeTfbDIhSy0Qgee7bu055pfnfqFAKuajiw1iDuPnRRmQ3zjvQAEFN52NVpCyJU1f9lYYaCnKvPj/7FbHaG2MDb7RMNGaDHLAJH0dtbVOxbvMPQR69H4KFmrMb7sPVJvNWe/giW7zcmxxARwJLuiOuS1svjW92/NTcufIKQW4VHGs7ofAmYERnH8lcA5h7FjDu76br+5mOiObG79VC5QWm34VTJ8Gr7zVA/Rs4WzbAPE2NoQfi1QlFBwoxgqLSIxFXrJ4+bryzOvF99/+l+FrblHbuKrokif28BNZoNYPXm90vhRO/ZiqfNNKl7uEQZyfcL9EUl0sQWuoKnex3lDetUv2y+PLrgzExG2XpqWjGkaD1TO2V+9y/mQ/TyLh/ReVpK9G3KZxyM3duf+VBeyE1y9ZIH9QnyDUaHANKidfpiLitv9//ktUT1SHznB+5YySrdkBHw44Ec63wjY/dMqBaZAE=
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