bB2Myg5HCBSprOzHaJc7u/UKMpfWeOrGXTi07OZZMYMuzOwkzsebI27yIaGsJw9zIju/I2NabiHZY7xg13szZ1kgsg3hjWJOyIBWXdYztzioiAgJk+nuMj069GX/OGASHYQAhzovQeZTW1P4xpAdA1Vm35aixOblPlydgkou/YWv3g4nzjKxmQ3YlAL6H/03kF3+cdPMkvih3wofK075wk0V4Ew+HwdgV/z8bQ4J/Yy3c3dPyqYm79IN8c4sXvWd9zf9K6TD26+c9iMfbgAp/AW1ru5L4mPOX2hbQmBgiy3HiXl6ll+yFNBuj7mrfjo/vw6EYrseqXKZWny/knmeZtRVzDqCZPTMVHbEebea3BC8prH6b7niAxxVbuMq3vR3mWrXIgM6BeSr7GGpIlcCWquAsSp/BZd0xEyljGfQ76QHtfIZ6EtsGaJHQ67ClBznGLioU3JwJ2QNSsbZQtlX7aOmhJK/VT9QO7QTJ6dLyV+V3+Jv1tYC6FDHr/UYZCR+FdQsUYrCv1emeHJGHSYix7MwY/C464Zg45hPtZ32zdrrY/HPDX0DjN/sz91JqYnxMoJWHRJP3vexvanBztmrHDI/vG2XPkgmyG1YGB64dh9eg5BGYf8Ec0d1Ljid/n6j1s5oG1zkSphWQNfQf+IAbjccaRNbSdLCeMu8/55AW40nUaMgJz8v6sVZ6LR7B32b964lc4lR0zsazySMqFHl46F8o5BkzSebaDlqeF46+jf83EKVERtlpeYNOzowLXmhkBWhvHNGkUTobY5+5VYdf3Rn245+APCnyVav4RUFvtfs1R1ioscgBnytD1WVKzkj0aggAcrQWFYQqtWzSeOmJ4GAF7fFYhRjkME4wgdk7L38w3XaEGgRoT+7zQ81YtYABzYgwtWpbWbkyxtxUIl+0cXeZsEK+OEvy/a/P+0otjSn6deXuBn+EVwYqRYXXuwfhbkpfZ2g10KE7s92/3zuixl3utMF4jvlrUM+xwi6H8b8hy4l/I7ORFqVd+Swnx2tNdTgEs1ufOWGAu2qoqChDYeKqaQ2eBlO4FGHAvc0W7zREcjJ1uCVDTZwH39RZmcY/ro7N5ZSl7YJ92uquSzcvnbswVZgsjfQzVL7dC1HtPvrM4fWv05GHKeWAlAegqBbwKphKWPhlfTdXLE6jtfTL+EIZvyFMFpAr2W5PcVtVtlhoofwed4N4xAAe1r8NrzdGcl6A6tWY0yZpIARAQawDunwuR2hyCqOTbyQvrzV/xykyVwOLYcbyFZk80BMdD5fyZaIxzL0NjopvFtdNYaqnPpNN/XAKieqm38Fsl/IsBqLUSTrRDqyAef34FZhX/wlrWblUo/oyWTAGwHobNUm/Q2UnrUbvFBThWL27GM=
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