ATC9ic3zi9yN4cB4f8jrNYMxdWOLv6rL1mMCgWdkPIEMw3igHlLvVZHS6J+jTluDBiQT+zCYk+G9GBM1ztV/qAP91JmE9EyTqpuxzMmRF0sbX0RS2BvqPwna3xX8WZBciLHxP0kX2xOAwJw/jgDJnBRMCFvJ/uWDpJTpL64JD0hlr6y0JYCN1GVJ/1XeYcgVy4g3F0BG+rRZwYtZQE+JzrtHr1aFz0W75kDr6aBDK6EYfIu74jDpwTC3+shIHw6FsBYn9Hk7Bdfck7V8X07RgZXffgNrWPfestD/EktTcDncmc+cXOBJ9h//mynPos3uygJ3id8g93Lou8K71ycKffBWPLxIdT3frFrFbvh0KSfWAlAkERBriPwk+K37b0+qTKjG5W0UhHq6ewNIggy+NTHyYCJaKEOKAB9AtV4A9xPXp0QrSzgk092WS5RZsvlHJiM7thV15nE11kvUbZ+eRVreMsnq4wQj/thW3DVphV4o/rhy9m4uxRzyOLDhfn6976bBoZf2xtocu3s++kNR/aNHNarnCJEKUF57iJ8Q1pO7HnegxPxkAAa7w54q0omka6hn0WKWW9Jrvpgqpa2GY6UjlvSA00f932Hn9/CtCuEDJXbOf5sHXXIBLXnSB9h8WLzb4idPHswkgGIRVWOkAEFKCzkK1XHxdaspfB1rh/WvUhdKrdWHJ4WuRlLl52NTi89Eo5QudBPU1eljKmrQIq+P0/X6ou+Vq32if7J471KBSdLMWjpW3ViXV44Ve/hmGd9zBAAUPKSOgg9K/0cESCWe8L0cdbEvQOopYSDjcpu1rYExyxSfYhwPtC7Xp1oUPreukEM1e2Fr5FIFzAm2VUP7HsKDjZ1h8oZPHvnKzoVGsSY+bM7+h/N+6C4maHNMx+F6qd9ps5DHXqpF2dnwRl3mSsP/I2sursULd6R8UFbBTu7c7b2WeVNVz2zCf2inLRUTCi5sBYztzbPeILx3SHexkqCjYQraR7f+iY1HJVA7w565hizYtsIoXqZ2zMbZaVQX8dS+jNv246U5EmNx2USRgBYTPK6W6UIecRlXM00yfKEWENo+cjnwHOsRvURvXxF5JY9pNekRQ1XLDTECe91GQg1EbqgWm+Cba5eEsWsTEBF//GcPZveWXDLxpXMBsGY2SkodzxzOwT71TyHz7ywWdALkZbz3Eh2uteWqxP7O7GkDTMgGOv3MtoxjzzeyY++QhGuWNliPZc8KCvv2G7OEFGnB4K5jX3M6tR5EwcgRMfeCs/TtU6NAW7jypgg1hApav/G/6QwpjTlOzHcGdAFsyAw4C+eQxWtpyCgNlP/gd56EoJA0qwI6o7EwA7NUSL2Yc8J6Vuh3+MNjMCZeq62D55YYZIm/7z1KTZc=
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