zM0iJfGVSASCvptl5UeYgaTzaeo590ZNqWJApM7QXDciL6s521rgWe0WFxyjxjozxdoLqkgZ+OuTFErt972LhyHbmPDNaZcEjh47PsPMqdotCotpNXtnsqXCdrbbUzuzMSdVfUzkxJLyB1EudskYJn7hlC5Ej++eaOoMivImg9p+ZGL1BBNjBKRkAvufwlxIWWyOZAKQFwYHQCXsE5pQjCvWHjgn7KMH22NVT3bEpcd+aHou4X46wpPI7KQ+vIkRiS2U7bdPem+mcfazIjbOhH/O8oE+17F1P2hQTQUV8rXZog6bYpmCqctzcDwLEstHHFt/88sCgPwEQLlIB5y3iiXIAIBMiD0x70VGiNs4BgN3nUBkv8vwfWXDzK2v7oPpLgbgM6DHfuSOr04uaqPV3ZGrd7+bTeJ1ZMaFYuqoi3JOzIWGNu6HvVbcbcQ0hD7gnWWMKrufuRm4FstdhB4N31B9MgbHbymXzTfoWrB/qMHkH2AnzYtAx00mcwwyKE8aq7Trrmlf9DqGOZo3Agy1vnB8TAdUSKGYCV9UEJ0d29A9KbMlN54eDtsS0pb+HXnCM2Y7ouGAr1rAF6UmL4UVRZ3LWC10MMvR4KBnnfgvp1150F03Cmbxm3Sh801ldWsc+6yV7o+bYiflGTXb9LW7Ju1EYXUKAc3XHgF4LmCFU93+ezzHInPlKYkZUoaqz51wQEjgV3SEqpp5226wLIr0ul/ZBvMxFjIbZ6rEHNUM4iN630k8JlHe+FyShKI8RUjzZGQ3JttVfxw29t+g4ReAvT4SWsC1hBkX/qpuIisuoin6we5kqLQmYfGlc/5qgpfPZW9TfY+4odydJlInv7dUQxFUx0DnbQSCp59/+FAahBmXQjo3T3gxk9YYd3yBRGaHjgmzMVqc35ons2q+EMQELOw8XGVRjCcBYFvoX8mfITaS7ZafB0dngK2tjh+Ihx/VIJMjt9qJ+C8I359BTyBGaOxBJmp6t1CzNsUSpXz8UGb6GwQ/ybtFTmJQiJlWuC4+JGnEHJlMbgGD4rr4fkECNvZVG4tyV/1r8JCb87UQ/0wMkhKK85W7tNE4+LdvBZ0QtPHcgE0YsYNRfZkfit/sxvoBd7jbRZK+I7sxlBYreyPIXVj+woLvpv9QyzqvNetqlDDUGufZAg5hW46KaBubN2JZVU/EjIfVCPyAYhdAGkWrRnNv/S0asbnOIlsvmnprzKp99+8e/+PI/zsRJt2CKYTyUyhbugvquR6jA4eijnaHA3/JqyMnrdrbwzFvOCJZ0fcRA1p6zXIqu+4E3j4q+HLBJkCMVTc7FXXTrvzjE3S9YsVlKETageZcco3EZBG/2Myqt6uxHK/qg4bd8XTMLeg4LLG69IkLpK5nIL4=
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