7ZDExQo7YMECJHEowXdi1uq4fgMlPUGb4yLq6nBG+vWoiz4FwRwIQtliZzb6qxFox9xKKpvUAGlL75oQ4jmLG79Nn2JXLtTLqXbHDQ5bRdOZDZnmNox27m3rqI3AUPzRK4UwLCfDpbTH2QtU8/E7Oy8u/zhaij5EHbBvsJOyZEiG0SscEwffG7cosG94bn6Zb2qZwAemwBfMlf1hBZcPky+K81cMJN4ehi2xKUaXG++pbQWaC8IDCIfdFaBtDX1mgNdDhQIMtqueugHWr1L8LvvdiM2TrXjKKIYOp+n+9ssRfT2R2PrsOCTDcL4vTIEcIg1i/9ZaJvHGpGupwvTjxfP2D/0fqvNMPAYYgsIFWCzKzg0tfe5KT1Epm8l4nLelfCjU7RboGO5vbWdA8MpR+GLRpD7CUhZyQ97u6TunGiIA1cWU4ae5trhW65n9KXksm6dJLidUOYX8Wly5UnglvUwWOiFvFgKYN4A2O/xDYCD3lOhCzA2Af3jhVR2qQQNS+Ljhg5I2A1MTrL1pzQD2yKQPIayLuKgR5pNDioJpQ9/DO1z8t52hQbb9+LPYzPhC2OVMouH/a9c5UZ6GJhI5+SfvoE/HX+3wsROY/94pe5czRNi2AF99gLcrIM2RH77z2zzSTYf7RYwir61vSW0eTzH4HaTaHjk51Awms2imDTx/KJJS/6RO2TbQsAKGfkLOcUBX71AKRbExIhjuESTPhcos7Z7cvAh+hTjZg0AVJYBoSCrTN3kNh1kBmm84mbRwGwk9OqUT0WoqnCfzNqSEeCwGQ+PyEv/6I57nEK89FcRDC/pM9+yM0Vy7Bf2KnK0LhrKSElmYb80uRKrB6WlYCKr7M2azdrpeJtr5igkTZLa9xoVhY6KhBW44r4q/RTFhNNQ8dmEh33yXZ/AgtHekkPVXUcsUvk2JOFg4vAj3w+lqbWI3YytEbl+xP5IW0Y/jymaAwNRTB8E+AY+kqi/EBkczbmVVZ3amUEjeGZ6oPjA2+MACXRBjYSpSVsoMHIX0kGwbURkqEXSiJwbMoFv3s9/7nj6OqjrsZzbCE6KnbtiSNI3nlVOlFKeXCuvExBvylizmgIbKcl+WEB9r0RAJFpyteYkOBRcIz/QEqQRo4TW9hq2K36dZs4EGWrFMRHzeRj2vpYkPv1P8xXFKyNCtjuHuDFVyzPk3omOSuxezFI6pMNVoLRhJGtJ4yDnGZ+0mAuYr/Qw93xAv0nXqX+nw+pSFprMHWz8dnihziSrEejAU7ovJHyu/9V5TlG9RChLPhxDo+ERkfY4B3X7ynrCNANdSUnfdBwTEc5HBXbG3NnTW2vH+jqq1lQYXQYTUjYnS8u88Qfnms2b7ruNDTcdo4oPdTf7E5Tq169OTzrs=
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