usSxWj11QL6rUZV9dvT8sTSu5Rt/1XwjAYRhYWkvzeZL/rF6ti8YggteCu0sU3QqgotBKUUkwC5HNdl/HrQ40i4Md48QCvFP6TCvEvL6ImkP4CPIvKi5l+vFDhuBQvy9bjsFFjwVvrlOpQHvi6NieTLca2voJFCK3qUnLseyqamekixQIOV+iqpY9RH3W61qna9EAju95oj7IGgLwmHC+pCJxmAy9bsFUHBo2SCrAgFqaZ8/GGGgvY0MFV8WAbNSyBkkxxEY9dZzXipTQb0CFVDw1/IZLtCTceRH+I/yrZihDrQPiYvsbhP89AUkgkJTUKQiPpc89hDtDp9GJiMS3UEv9mwa0Qzqds1SifkYUKIMfmlCJ8TNlERL4J5nQxwCSe62L/DE5Bok98mKKhpaSB9GpdoAaIQAmFb/EiJAn4/R8IMtIudgoTZU+AsCONRmi7PWjhRv/3zZwW5IN+SyDrgN5+OU9WrqU4m7UMnbXasugVwhs94HEcLi02Zb/KY1mzo3AjAGcFC05iOujLJXnAyuDYpNi3hnv1HzgGF3mYAHuoPnS/Eo9zj1kpy/8IGyGrV2lET2EuNhWQ0Bwd8H1/TSiCiVtk//p1zqeCL0So829AbTeXYEMkXEQO9XMYx0TZmNGSxs8NEyzZaTB2SCYx5n/eHxg+pL5iKJzlrUfLiqqdDInrG7NUObJcLBlgQQSE8QTIFQndHRJVfAghsYuL+eWtMiWY4+79V8sS5C98l/J+DGZcu8J9N49qzAv5E+J5kBZUxqpKdUCr77AiLuQrhQcunNr3i8sy54iYXbnAfhidnyIBVtncIiYmTrA61d/ueylxK5CboY2pQ3Cbqi7kht/VvAWDAP8pfcYRAiNxUwbncHvijkatUhmIlzDf6fO++kBuY0KBX6m/1G8Gs6rg+K3IvGbXNYdmgBcLnsB6UTnL3WB0aQNATlpBvknwLde7Qda5H8kTpLkB4TKcrzxNDEJjd3QQ2K+FULqT7I4UZzjUq7vBCxiptTLT4Fp9GYNgv57QS/JFkLPVl6nIUHOfyP5E4I9OOBlZ4Y/K8wnBvneMaOLi4leWN2iqfUpQlIa9mjFu13pQOuIJY7+SS8bUJsYQyvX1vh5PpGjaadeQ4Sj+Me2hAmZ/cr6RVItda98ikJYCBwipUaTtALSuFuSgbQ/YUO9Ly/lgiTTo8zdzSY+6quJYuSboNfbtHP6RXifdLD3bhxdLldnorl5ZY/7EKGZTZtPoLijiol1bhwt+ibJdLE18emVvYmNWbbBZrzIN7G8CrFVgnAAJjSy7BDiB7FwgR8XAWsgnYpb3sCFivtDitABnIOoEtGLsqDGKak5y7zeTL4Po3ArjjEUNyLU8c5nG7gZ5Mii1dsi+A=
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