Nwm+jMoLaV15TmXy2+OdsyZUkZXRKxB2Hg7nRe9xlAUcZK+ptZiiAk1FFq5MCvGgFgaIVuXMuquSLExWRh1aBNy0pmWgqvZTVwWNDo1RICbSF5qGcDb35/2VJw/aDWz6ad/FUe03CbREeae5pB1EcEbBywujZAarDXFhxYKwRb/RVj3YScGdB5zKMeknBiLO9Jruc1fwzxMAGCXpJI6Sq2+aga1cxmFvMKOpxnHzJj7LuXJcMkQo9LDyjh/QtVLtqo+1AbehkiCxgci+WPBIkycd4z2YGDaiuFNYHzDW8/2e0F7lAymVX+S/fyDZeSSu/waShygNbHsb0/VTAnLbZEyRhKaWcGLU0ijamENuSyQVJj+JlmSfkBIu1OyCw+FNXXn3s9rPbaubKwP7Z2ttKg9cTuTDtJ9HqLecDJl6P+17g6wYnQh228nlTsicWCHmqIAYNDDqwj8BMiV8ZuTnSHbQVeH85rfqShNQQHsHVqAZ1WbDB7UWX6NIUoyMO9QPlZymWq4//Jkun4TDQpK18fdAjPYa+wNOKXw37dmxhreJwMMjdowzgXhHHaNehPf7gqu6m64x7e1nzyGLWRHgV9xvMjf19gpkE4l54toGEr6j9vG0WZ3xU0DH6cb+yjCpcn13g3NOlAWgNYFzagaUzyry9OLDjHIDS0cUJw0VJkLTXnKNwx4AJK0LnixtekQMqPeSjmKVXHZz7LnY73buIhvClnCTsCiwXpOsTeuPbvxCsxzHvOyCC4h/wLi4JUoXLuSbcfME904gcK6qTHiZFtS4aAG0+VHnJs/SzsQes6WqVzUoLBJKdq/lXuaKp8R6lfL98z+F8FMF6w3rwy09NUCFXdTLC4Y8X4cBkkqYfg1sEGEsJwHpFLCdVYgkHAdCj0j9DyI6dWUs6+ky3E8kvgr+E7Agp9DySp+wRRShI92BSePndQwTvvjASxuEBra9VTGe6QZjMQ6bDXE2XQMeWjk331H2wycv0OqmPkv9QETQp/30m8jxgdj0euY/Lbq0ehsWmf65u2vLSrEspAR3Oc3kQWr0OXxkOUZb6VXB7sbgCSleY1TA7hpmJCu5YRF2bj8xyjP4PGoMa1HZWxau+wPvYR85UB0898SkArlrM77QTWwrTF8XGq3k4fnBJa3h3AKEjGDg8/1Yyp/+LUmYrz3b8lEOAEBNpnBet0awYdQPTYZMDGP+dVHTy4e8XC6OXHxwYmMvid/Y2Z6tGgPHIirQeXMeVDxEJg95X6IQcK0yLiBwUcFfk5Cv/IVeUdkVxZ7njrZOyqSdMH/IRppyqVM9gASK0GOhq1BxBSQgrBb3eF7gQP20qZLnDRrHDuYItYsFNumdMeWQr5Xp7P71N09yPR/sBexRJxQqCE8=
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