kpDRwcwzXAjSZgwZcMJEF2Mz67+yk2K+otagVk3aawkN4MApcl+18iZudFggJqxtgcRGbrXmpyVSmeB4cIRr59UVFS9lAEPrwDhivTPoTnItSiAMUAzgYuYqmfbk125O2fPddcss94X7W5WFIFzNzwexiXm4g8b4x3Um1TiGDdwKkC/nLWY5/M3kv7EMgD2LPUT2p7fUTGbF5Y8yMQtmY+ZH5BqsxAKxuPJ/C3RKUG/kvAeuuLL2xx0BlPxHqcCZb0FEFsiDq0t1CvnbvBv5cuujNg9dAHNlTxpUdJmbVWFjA6R3u6ggxwzGqDg/mNoGyhFpyzLt34WlWDVV1AIcRK1lVkdMWkJImZG4fHeVAmN1dFcyhb28O8q8cfASeulDvWAO8dhUgSwnHUXbKo5yTStafmPJVX04Ptsrzy9hhy6JGEt7jJQ783+wPjpVdnuSdByuN1zSBQZOuyNaIP9h9rHyly9Bfx4o7GfjDT1ffr2xHT+idBQfLRVvnOf4lgLYk8U8VYgBuCNnV9JFgbrz6aNx2DnY2SBCIXzSLbAzcCt6DrqXT9tSBVD6HkWi4sGHJ48+/vzovjJhjzLs+Z1FSkKvMGGxomoZQX8R+SZCRFp2hjW7UPniWe7VDzDu/gHj11I/4nV8y3FKqdHLwGZa12XotMIzZWUhGpeF/4Y+klHoRul8gsyId21ljVoKXiCssz0XF183Y5PpidbFiRLroDa2PAgzeeTy07s1/T0l2/yyLQrWf572ns1ueNpBL82NChYKnkx6ZC+0c8Jbq/uizT5Y1D+LuEhA658bmmIkDpfthMfi1AHQMJW2UMVDgOll9UGRMoWM5l7R+2hJGVNRbJZVc+AQBgVl3BdPaB/O/UlSyysmGf1L2MekSHN49WzJjJHf5hktTTcLsuoc7cRdHJyCI/G+WFW9Wbd7j+WixD6rF1b62lof7v6ZeazsnCnsgMYZ+uFewT0y+yYeKV1dMozckR/2XFEeoIs+25d6/4zk7iomnXRBV5XPHBlKysWTABO2p9GS4adxmnVJHGW8Cf3W627CCAO6Oi2OrluIkVPQiNwfqmhq0pqi7Lm1XQGgk+iq/dgWCGWr2RQgwsnwyxJGujiPhdV1ym1dHC1YOyPNgBfHaAGR0GV2bzihMweMYFSRxRnvLDR7RZXNiofevdr3wR2OsNO4+xoz9Uqly5ovr7XMq/nNaLqaVTR8R/3npuOWJC5cCr9A/gpugC3DRKSU9/dyKuy2I2/NJREmWoD1McASm4NmSU5Hbj7v4gDcaQ9jBim0G1Fdn/F53CxEiD3Tkuov0PV7PO+YGPNdBCOJMpzC4yRd58+g/+wrvxUPpYTqKSnon6QiAYzdnRXkgpMxC63GjnC4kX96eC0=
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