TwxlLCToATKY0SU0DpWIClCgUVUK3AC3CWaRF1e2Mn2lPdemjox8Y9d95TVnPuYMA14p2KG0F+ADNbJZyQ2xyEpppxG4b1VuYxdZxySnwMHyWgAcRen4qv2DhMwRv8N5+whOog8Z0ceG/rLis5+bzmf0pWn66uwEPCtxpdA8s6cCSpjNN7zu6FD58hZfJ/Y1fat4YN6Eh7A4nIigqqNlQlwBtE9xvD41b6y8kNGujNitK0OwBdz/ck9XHs+3TOolXVQfeF1smE/qc97Mic4xLs+mF+fssTsUqKjUjXmjwQzMWZaundGKPxPiKnUkQfOjDjBnK0HmbbklxmrOWw7Bgj1EZkY+SgkPnJ8YmJKwz9g51XRS1BNAqNhtQP1Nlt5NZD9+6u7tzkvpo/Ksp6Hdpbuoj1+dotlxkvljZwHj6RfC2oTaAdAf7IjWMwk+GeJXWxKXAndf3JWdaoVnA649S+lsSslgYr0hPoIl4NuaVSPK2zm1NDKhF3JWkMr7MpoolRWTVJt+YAOPwW4ZrSGW0tJ9wR/iENl3KOcPTzV37REPoivCU5l4Rix4NGwn3PmaeFAQLMDJmTL075JoEXFu2dIRdlErOPM+8zscnZkacIuaLl4OYw2ktfKB3rT8+s42kG4p+kuMKPv9EtrEscHGJH/OUJEOo1w62JNe+G2cnwc+UmO/PLpzMk4fT2Cpm26QdoE3T/+ja2RCe/kCtz99BhXhtXPzEfG4MpgNiMq7NDQAkxdeI183kwatZoarWqHereqHyLhCX8sGATHnsf9kei5wTxUrYbm0J3kgo/+P5Cv/Ix3cU6QduYAWqYY0zJG0sdv/he7ipGxm243EMmN30+e9baD4+aQcnToTgngBFWbVY/kHdhaCZdm87hduXX6hQ8n6s0LXBQTYbfS4H78Wuq+K9OaOY59kZJamCIGasTOaQ9xoRY8mapua/GXIxI9QUHtsaSoRUEKoQ+1z47NatFGHnNgx8EQ/284ssOBzh9hfsI94y0rCs7zVVPThocfE3HCCTsTAr965fK/B6/xPNIecwVdYEjag1ihpkAmzOdH3MtMSb8uIoflnhg/sXlGpYXaZ0e+ftDuCpnYrDc6BvkDJGJgc+c9YE6Ta6N2OmmufiRfwB7vcFpwaTb1FkxdWYis/T45qGfZdR2E2dGPQW1Cr5HSwX5UOznkv6CPTu2uwKIE4F+hC/xISwZj9hIUVR7ba5xvisUJ1FF4EOVuxEIV0T0thFr/7xnk/5iBfG+LF3vfH1Eslkabsy4kD6VYh6HifPNbvZGlhY0HBnkz5Ci6vh03knx/gNkbtvUBeKpP+91U3+fp88gxKVjmDiVjhMMNVgXu473C5uRSOEorG8sNrOF+5Izw9jQB6Xu0=
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