pMV9vJvzgcXWbiIjy+EFdH+zpdc31HZYTEC4W12K/yUy2Bm9fwxTSOStyaBsd88I/QukgvCUrFcdwT9la0FmYdFj96jNKrMBkGthl5blL/89U6uXqt3HW5DLPxrGif3o59aE3y7qde/Gz6K4PF+sjZ/f1MTS5PYshHd9VuLzkgcChE/p//r9XBMewIaIueIgaHo7cC1rlQmv4ivzA5rWy6hs89t++zuNgmLe0HkCX3Rr61mDUzyzBvE4Ur3THsTLZptWMp2FYO9fmrFQVhQgMDE9CurqIFSl3fawe6eI2UYpTlO2e9scmu5CIZNQPXKpk0q2XvHF25CphYvDNlLUURmlXtwssKLHuEFo7aqVrZhTMCVXlV0RfqxGDASAd4aWo7HYDRFsI94CNGkseis07YTaeEan2m7Y7rAxv9zKf6TcNj2lc5m4I49DuEVf8oEvBNRq+GtuANbFdwDLIiRyeZi+p4h3KPopFjmEyLT32zcaGsOfFjGJJ8GQ3s72sHdS5M+epmaN5W646Sq/ostD02+bQTbn5Tm+lYQq7NvYWstnFgl56djxdEaCE6SRzy5+M6xgmZ8h5Ac37Lt0L+ETMlhjm3IAC+1g3d1pljwWQFYlOgqMLJwxb7Y9HMIm1vWEnPv2yGHur4LSYEBT/5XL41dexGosqDGZut7+aGIFkw7CZzD7b78MZTAzxDkUtAVpByEUiLbQmog/Npzm/CVED4QRoabGRW+DO9Pr4XEhfrlJALEDRVHKyhJ58Vqfcp1mbgD8tPo6NahWSsAQzOnmFMTeKbIshvrTdJmGT9o/303J3uwrK92J7lpQaG937yioOzvU7tu8GXDJ8c+iR1ibC0JB+V0QPidR6sRJhtjPTrmymvJVrtftZeCKGsLWfzn1Qp55jGPS3HSP8lwSWUiHApFda9Sapiz8PNuCO0B60+DmmhSRF/jm5SxRojq5S5WFcdSNhEPNfvh3Bss0sHCkfJwrdcxQwMzbgpSzlBS+rB683RoLlnBz0WY8tCQWBMOr5Raz1SmFJU6epHDm7KoSAgtNPHnQXy2v84KEeoi0Ry1vfraIma+1akG/FsYTy43XdMQPOjDxsR2oqgJD/9KecdThrX5Z0UL1269niiQ/HpkNHsTx1QAAyG4J9pgTMmLknz8DC3PYPoWmU9dK5P83fvR/GcFBhsEgalTK1Dnt7giLfOOvzAgydKK3OwDeU8/9+YA/spxBtJ+UeWV09aKwEjs1vi1zZYncRKm6YpZ4Yn6DQ+4USmrgiq8H0hx1MCHX5iPFOx2PJ/id+0bmuhRE8C/dxi7qQ6LJUM1Y4ds2Q1/fqml7TaLkoxUviW6WaNW8GtnDhjyBUHXQT2ku5aTwusZZ620M/nrn+DitPcU=
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