DNA9pjGlFRIJMSeQs7WVNrlf9dHGIFjJIOMLgO6XAnrqZXrNNYznmb8AcIk6QorkImeGrkjfuDIUCMwIwUBSwwDBdKCXgVOY6u+uwmxb81njXJwGpU8Uy5KFxWUbuKw0GhpV+dA50AG92l98AOFO+PrMLV7EI1dJmY7y0qC4g2A+86Q3i6li3qj7Mlce5llanRFuEqp7kaPHf/ftC41xhhu3Mjja4YUnuIfCr0WdLjWTzRsL9vveGs3FKm2btk9z5QYPPy9E3EoUryE4FQ86O8pTeuCyc/09T1/H92+YzcFEcfSxulhZNxbmPWCbzV2DlOESjMLh/Uz83YSCk2WjabRf4xmRU5r9GDs/VH7rpv0N8In2zhAalogyE+FTNzdwThUfyjZ8O/m0f6C7LyljEtsOB1qIeEdNkjOHXsVtS71WYoXZ/ION+gqFa30uhixPz+TBwXI6GQfWEd/IPmzJEoefkl1jiVuPgZmqfENEVTWIDYYqHwtVdCMhFDXShAANqMFkvJP+/I8reBSSMnDYvqfTml7lxNU+LA8Mn4QwBx7AcnVblVcxprckvJ9SEbuc8XLaKdivbN3cJ4Xu6L0WXkGQlxKZYIOdEToJCv0vuSCtPQMMHmTLrSl2V60gSwb9dyBWvZpyCUF8RMcVPcpUbfhnEyc5+zt0V883x66Nk3dcAHbbX/YKh+ifG7i0XN5MEE0I4eM/0ezt8Bf8yBhLM0nRQ9iIiE0Vl0iJDzMjHOpMSsqBzolJzEEBaHdIsD9hP4sIW1Dh1MmOF3ToEJqVHm/aD//CeWu5qRszn/YtvH+mXHKblnhT/2Oa1vZekRqrkHxhuG7A+VpkBGvAlaTKTxh6Q5DwKNKwQitrIBdVcRssHF6y208zTZDejVB4bYYZP8MP1VIlqi0I+LzTjX/gCRtKtr/8SHConw7DLOxcWNzbVV1yUz/7QpsAUu+51et7M8qnrNRsSnlajoLtJqkkIxlaNTguwaLFcpAwq2ktHsAP5llux+yfogUdV7R6WbBH64FQWcCjBlFVA1McJjLsg1hLiPBoo7a4wztqFS+NPvTBPuaZRoZGZJgtRTzWGyl/yPxTVGE9cdQwOB45wpsca4TGPkXPuoANi0Fm8nFvSHRi/W6FtkxRLQYPIZ27F/DZCW5+9lwHlu9Qgers9hodkr0CPQZKNssaG8hUvgskJCEtS9AusFZsbt6yo/63+n7w/P42cfgCWJerHrCr7FRo9GX68+11zJhCrYcJI+z5l0yD5QtojgqoWvLoeYjffRvMSu3IY3bkqrcRQgwPHngpZlmGFCbWd3bGdOBEo8CutXCfpGbENquv7LDtN3RYVvz87WLiwH7LqRG9BLFKEErzLpQQZ3vP4U2FaPNuYgQ=
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