Sa4p9iAnOOC8E6ipnDc96Hm1XAOsX+ttO8T+ZOxmChdNK7M8GDKfRvYXre/76aZ5CQWwbeig9v3yxSiVjGlFQY7wFLdmyPQoGYvYF3fbPvGx23uFq8ABE9O7wYHMpiLlfUbQqkr3kzZfZ1uXllZ5pqLlCN5Y6L8AoQmt0s2ldmGynl+dUZXJmBLzXne4GveeTgQ4fQoK2CtQUCpghnwcsJC/vArCkKc7f8EXUB/lgjdIRSEcR/gCiW7jylwGzCRbC5vJ8Dpc+njUq629xhuGcqf+PUI9+5MBDmlbvLQXUlt00PX4YkwdwMPvZTymDssqa6ei21KA/BVMloYCH11kh/OcC7xCQCENkv41yea1d0ZBL1sgGFPKTvxGVzr7Jjy1e03P2yllHyylxbhWxLMqgfMUQnk54BJ/hy7b3F14QtJ2CJTTlrr+/tmwW7hYedZRk73gpuG/2VC76zsZy8NKmmq25Y0pxxThj3o7ffiAfS3FAZROdCZUXVRwnHRl8FO73nwJv524odiUeUiX1n2spVFRbqWGYdC4S0Jb6swYlxQT52aOWk9wMUoJsMHn+bCBvzqgAK+MkUmh6S/NLmL46wqjZd6gLx9D+Z7trV/CorC7oU08tj68/cqw4sFCnHNhBhLXxOSitdjKFToVyJLEBHDLFmEmWN0jchePPg3vEwjA32UdQi7S/jhkmGpD7G3HlRbDJAmoDYtDtZHSVHDalozlxvuUD6Gt/QU0n+4NJyAHpZF2tIzI9XdGORweBknGHq0bAl69xggFhqh5whGk9ExVYQ4Q/7vYWjJaqdtV4E5ec6v2oWnyAJrACqdNLX0+Mos1dwCqHLbsr5E/nAuEcjHTEHUF6RosWpEx2wEbkv3FcCYOYLxf5SDn4YCvC5OPq0U1ttP3tdpWHpmT+7Pj/vQ+/kJrirPaofie4NKue2JAvUOQiXWVNhKzuvvT66tITJijGdyf4ztoak/16HnqT7nCJwxu8mW347s/d/fN7e59BVwcAARhPEj03k1Cfzm/w1DpEh4a0O1KNvoKwjSTJUAv5Rp8RQ/u/lY0e0k2/RD8HDrIQ3ssOL6Ku90EJ/kHTvIOFF7lS3o/8o78mmsia5OxPgxYDTSP+kQ9ZZeYb5R4nmD5iZ4nuuHTIkZmt4Wlxeqb9mWm/+ZDgYNk5eJQHKR3EjyYTROXC17Ejdn48FNIKG3iHHZki8NIP480vFj5OZM6B2vzFL62P+P8DZoQvBReHTRESWiXScaegJ4z6Q3oQS8XdNT1s6SmmwNUdLVmpcUmNpb64Wzf7+yHjSo0H/AiHLy23XrKgIywxoyfvm1DH1zkBTSNQgTSulR0qT8g3VHLWJyUcFjG3qtLD+t8kyGJ4IRGN1gWF5nMN7s=
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