nOx4gA8uFP6jR7Zc5OMfnaZRYPsuOsIGVwDGtw9JOwJ6g7esqQ+npzzXrqIqtlXxRawU3fCEc/mkSvhV/tPxHYb8jiNnMT7tIjr0GB3oBkmkwZeq3xJG5XE2jDBmAD9DftS6Rt1Qz/hvZq4oCF6nbMoweTHDwH+CTVsWok/+CkF9xZVhkXEcilZO8yfDzFLEnTGjtXLlATkedzecD9gIoL6ENchkUiH6DlkIXCpYM1tRPQTlq0UU88salyLYi8OoCkTkNZy1jTdCD4o7axiYjihWkLxqVdGJDo6kxnjvt+aBSBWD/aARmhAxnM2qB+1r5EqMfacGsQPxFjcHF2tNIFqEgEbh03Owg6CuOGmDPY+hJ8SEGFYmKR/ZlD+JjErpDlwT5M4OYpzFKCdRLnI50w5T3JjfkQDPPSbCURvXV7FASuQvcmLNgR11hHh2GBD8W5DBppgJidg+8X0TKRt97CuJ3wyJu9Rie8jppEK7MYbC7JJJVd6yTysrrqDbRdDfwuNKFdUFXWcfWlkDD8VfUwwiet3xsPQ7JFa2ARcALA1amrSArN2f6gjs8GhNGNpKVn3nb8lcmA4kpqod3Sw9Z++CbKDrniORyIX7AhDQ0G+lDfm0mdQPv9DX4Zf2z4BNxvKG1ffF2xwv3kWAuiRQkXxfXxuqg3Exl9V0UqXHOg1CZ2Tc6U5wCpKtrPXM2E7I+Xdp5k3CN8ctOCQbB5UlrTrnWwuaTPJLEIvw6K6NVa0nsNvuw28cIwJepdapodXFndD6WdMbzusEdmEW31W1ujVlBUW8iKepSlX11zM8w5F5ekOqZZjZJcdxSqEG1z0BTwvIycC7wawZBLMdqUlfgf6o+M9vGTCeKfg+QS9BZsx1dNT6GC/0tNTd4uXJaTMQBtAT8E/9zN6sZIhv+RG861kSh/KsHR4/ujvJQ+jNzMQfwg48MvqNQj+oU3Ilc7XJyYYDbMW585YWZ1BP4kmRQKIjGhG4/ooDZxoqdG9CNyyojwAv30U5gKiPXH86q/dWK7Tz9TUehuhx0AWstmKuW5UoF+CiShJOoofLVM2m18Hj/DX4InCYOpyBQ4F5qpPWUXMG++VIhJbbmzs3Q+0LwR8jAE/yovxOJOCkGlZgdmKl9XDnff13quv5XJQubr4hnYXdupfm98wKBhIXd4i8nLX8z+Am6lTgbURq5i+Ah1890g9kpTB4qa55QvBzcubLVIBKOrHcI3RzGhED60dy2fHrDcdpSfSJhr384LyVOouy5NgI4hnoJTjnkfutnc7GEnG4W5XK5ANp1jEPXsl9yuj3FSWJm8+tVFSpFUokcIEHu5oiTSEPJjunYKlh8B3bVov7QB6uxuhyomBT1G2DpnvDvLHtkGvQPBp/1i0=
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