9rFLeqzcHtc8Hn+4CGKbHepprQR8gmYPPm1RSLs6FK5rQvVv5KG6f4rGILDKQodjLi9h9F0oqCtsuTqWeJzph8qjnVd0ewPngtiBtUKODH9b5BMmbuUCc1ASDwf2SedJsp0x3RLsvxDRINWaOjYwm+mfLR9vtBUzftjeAtPhdLJj+AiUwmCrDBvgMJaeIv1/ahw4IjwQrtG2RpOToPx3jnDHpRV2M/EW4Dd9CVgRe40QRIlcEI3jIRXEcqNuy7/yl1vhgBne1oUFMShnbDPan6sJIPiqwRrISQLG2KLERcBOX6hxDzyFkmoEtpkQVnlQvKtBteicGkUiaSvxLEKCJvamjAisfdlraGBo0oHDXzr8TzS+mjwowfJFTHqtOOihR1d3lcGqB5BOQ1/WCYwRef29vDXylpnHrEnnWZI91r9jAqzYUnFuveCWCc0uBLQEixlLA2DJR86C23MvnnqVPO2hagwfbjYzR1ewfeWTEs0YgBQ9Dy+xYVPODy0mc72LyAG9jB/RU4t/1qGzV2SafZdMVINriT+elU6bErsj8LnP2U2wkLi8EB1IUMn8ZyYPM9nLkIA68ob7922taYdzK1OR6R1dUC0evJdmgz2zAn6p41UY77ICPlOcIZe5jaLAZIM8zzhxzn6M2dZh8OII5L5TDnHC9CmF5MJP9/yZveHrJ/fFvNVUplioIkO+zYuSjM+2d7H0Ales8L7ibgYZgCsREGqVn+AQNY9DzPF+043m0mjEPMqGbgvkdE8KjHW5fCwYEsSVkwTla0ZtksK5oY42ukYnikK6DXqMMODmDM3Zh/ztm8+OG6fFDxNCYvY6CQ1+DvweTyhVaXMTOcKF+v8AgmXeO8qna1KQ5GoNpa5J7b4HPlsIzZeKmRvOig9Rpn8lB6T+nsY1aSVzMDJR7T5xnoIsh3InKTYrEP1EuXdRzGRLLgffaaiv50qkRV3VSY1K7YYtEplhpWpaKk1N+l73Vd+jtJjjeWmL0noee7oJwHdXWQhDJdK7SKTZ4kbvR/a3krdH8Exu5YcNI5b87KVdtratAzqGi387yyb/OmrrnH6xHyxKeiUxRvH3tQ+qvMnO3TRZv4PgmOe8Bvu5kUq9UafvXn03OK7InzimeP3yomsBhmvjKVOGBsE/iMobii9Ka4XDKzoBaQxq+Cv5+q7P9kVPAd0DuIygwBjabbq88WrNJksSXbsoSq8coIWZX76REY1m6MO6LRQ1quID+IHyBtvhyrQie3zIn1zLRI3XE1QJR7d7jE81NcZusRld+cV3BoMVNRjeEqSS0Pe2ysusD2FNludZjzaCb5W3CL3fEqapeYiZEhtaH/8MFfONwmCx8+pPe216ZGKJ0pRqZiLdHok175qCKgE6XTE=
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