BhbzgZs5GMVOwGhfSPAhzibvvUuwakWtqgS1dYu5wG6/Fk+MSC7nR7DVxAe+yf/hzztF5C21Z7CGVTjpbByRL8u8MntrZoJccMJ3WbQHweiXTcg5HAmVsdqBOU4v8lFBFm9+GATrmWegkJuJ9+PMSiqCwRqZhCGh/+JpDrrL9C5PINXcMxGXztyG0VshgL3lhSSCZhKsCuvkx8GE+oppxfGQA2CgMRaPpAVC0UF5ULtFrdbu0bX7S1McBFfHZ5LZFfcYDJ9xAXfy1HIKoKRSn+GqY12qcMlV8BCS/JguJ0kxiXB0F3SqBttgVGvLCSnTCkE2mM4T8/B7NE5PIt9Je3ozjY8BsKHyumSSl13vOzSQpDevy/v0w8Usslf2BbHgaqccW1Wn10o1Eqg1ecGn1xmjZ4hJtSoReo50pSYfC6vPe1C1IbOggbBjaDT/VzABDTw6E1Q6sYOcHW86SdXWNQbXMM8ynpMKwOPSO/LN2NMXwDT3dLxSHm4jSPQlOq1Sh6h7WIj27840NbRrEleiSJoxYi8KRwY7D5arON5lXsNW1Y6bQ6uEvM4nbGfszML8yf2oZGCBvdrPqpu+sRVDHQZnIMiLcbXLkgbEyrXsmbLNrMACDmjFJCg5S+vEHciqv7VYNSg6z/jkDvjUC7bS/DDetX4jxxfzcZ9sJLDm1ReHsA38MG5nOZiXW5Cbo0vFz8ZJHCLViWQTSQuSDzMAJEm+TV5dbRC74ve08+5/1YYYeLKKtbbvX9eqbNMG2yBF6drnXFIDLES1Qg3bEuVo/uOaZMmfY6e4Z7T1kpuPBnueZnhvW3caaXzewZYJeAXayGOg+uB2C5wTfMkgmvTVTJ0YOCvZKWQH/qz74tWDhA3FHUBo2D1Aolaa+ZHEsNo39nk83cxCt41HhNrik7M7FAJNRzIAqLqALrCJivNZ2OXJtvabFw/yHk0OXUePAe5Cdnw7ojQZIh5ml2+fA/w8AY4BgT3TJXeiq+OZFKro2eDlRUZFmZeESU4PvLBXoshIECMHE4mmSDw/vbNYpq6qAQ/TIufjB+IIllav7j3GVySrsnxhjYaJ0C2P7QHxl/6mWu2U4J4JU41sTYJ3JDtBda0S+L8flrI5XickQLT0ZooPUQlPnccwe6QVetk4IsUtFlvOoW7kpOfhQDNMz1DPKRMFkpLgp/8EpXEZ8jeD80wXaIWTujkQS9OSauN+/P2dk4MwzNAq+L1MnNVfEEE6gR6pLuGy2kxjGOkYFPoYb6BBOLtzNOLM9YCEeDvNU7W8IoKOCRs7gL+xId63EKxH8/2KarK/Cb92MnyU/Ct0/+RNpPs+M95XfmB46GPLmtPUF0V55Ss+IINBW5VvhaBiFGeeO42Dt/yLZUauV4Y=
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