fLQRldUF+0JyzIivfT4AEz5U55CLEC7tnLiExR8CCewTWSULT+keLda2Nf5z7jSxrorM+GeNyd0G7IVAj3dxy/AMBDLeCOvAvOKrBitQODvbCz7w8PKZxmtHka2aocCGlE2aKRVT13S77i7nMvhxShwroRPfJ46lgvzykvbq3uBexSY8cIfKDGkKgD4MnDmPYPPKIuDv+/5kw34Z/AVPOKUNGJIh2mfiF8K9o/s3R59EcclcOWM9BSuXU5jqsj0uRf0SpmoROLyJCW6UC/WYoozxFM3VZzESMQzfeVJAFGxn7FQ7oDLudmKhZ8/8gSprmMgi2Vjn01kpjGsUk19vvOvI8yxRowrtAerS4n8gJL96asUDu+mFdm7yc5qdZQgCPumelMGACmmeBPMjU9ZHOzREuEnTBGaAwWkDGDgU8iyz6Hy6jfO4s+JXNVra9OeWenrIraYukeVQsJPn0lh77KaAW2bSIR0TX/Nx9ez+cMoyhCtnyp4YOMp23YZ48VdMZk2Cki1oJ5g72GVWdYsVCUAwx3wEIBFRDi0RDYEoM0FvW/3qSVBHk8J80lG8eq3oisPNN/8zOX6xI3wJ0pL8JzbhWn5AqRIXSaVB+CmRpjsPAEsodLPQkfew4M/1+ZVXaf2lQQVVHlFsC6RaW7x0pJF+GHPXiAgATwiMnzkzO6UeQnveJJSYjGTbR0lJxsZjdPvAoxlfMgaTOtbwZ11XBiQ3q8bBHd7firc2piwQKqJWXYXj4LEg83SI03WDQsij9LRpIPqzjl04f+W2fmxJ3xXXJRTj4UYoxLbCmSNarIOhIWDjNiwCVYKNX6YCVS9Z/FLnj7JDlZj8SWPsSIQKaei8VWXYx/KM4uEPtJZ4Y7tQG83J+IbNRa7qKgYZLUYmpmOBJpP5rO17NLK1ahNtdtYgw2+Cy4ng20qHaRGkHiXSBPgp8Ss5aHPZyHSWjcBpPu4YbDFqSU7jAUVE/mwd9DCdg+fqhgNBl52/6dXR+OsjQT+0oq/WGwtio3deP6cmifdJt+lyLwnlXIJOpD+0wbKLSGfHHy/HmmprYcmL8iT0UvF7tdTemNfOoR8fqb8Fu6+LRGGo/l0BdF2FOhfDcAgiHctBXUZmBX/N3p8Jq9ocC6VDTmIxpN7duDkHQvxUZi5G6G5RLTpd7Ue4xYHvlOu8DKx2aCg0wEMA4xhXCa6wO6Q9DtFeAWbAfUav5MbZsFWIZxT3I2DiUUsY1ywuLiwxE/EQvqXZoxhmcOyrEDhk0vRdCSMWJozqvUzI4IsEgZbpZAXRhayZsNBYqgEQcRhmRH5dJIQS9PngEb103cgVzlyZedJwR4MrmaJ27MPkwuCqRTPLc2yCgtOSrDsD4/wd0rP01OPTyq4y9LI=
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