jcI1eiTUPRvIoqyy9MXZCnNeYgu36ysJ4DqruKZhx4noD8auul23tCOFjvA07dnvDE/bOEqckKV3dwQkkcjyXLfV5CPG1vliToY3+I3f5tpqCjz9t/W2vUaBhpMSSVrNDhKedgGVvjGS9MJXq2QY8zZln2W5LTN8nJTEzsyXQM8SLccvP9sgkYB/tAvcRWP32EYGXzQ3RTDqUQZCZnRB2NWnWjVOPPz4FP1UJVKf+EyFCw58Iqk9Hl4dNJa2grWvylbp7p6wr+UElbodi6Gii2NDN7wxc1zwgcsv098uWmTd/Rnq73+i0DdczR50naJQqSJjOINitIStaZIs/Z4+oIuF3rX3wjTRMIZBkkhWJBVTwJp5ZHAAQwV9HvBNp5uZ7eQSE/h6tdZq8Ep+eWQfWdjV8K2QPSlsbRK38hSPsqyqrjz+BhYXCT59LiT5MswZD/zvWxbrmnIZ1sP9hAHJmjoDIblF2ivQ/5WXfs16AZgBygquyJ0Z8376YHHWb90M7k76z1NCDtSY6NAUQM9MtBxdr++LnLekCx1PqDrw/HMsboQQsDVwhTCbaKCMVcLZhXmiNaMmOxTWl6Qa0XGaPDGZ7mACcurW8e6S//vi5gROPRaHP5MZulUxEoyCpMJH1nqlfHAzeMrnbVnOe46rxQRSkcMRu2rPD9y7Vznl7STs+k08DSBB1sDRl8Emxi3jD8l4rcmd51u57xZqh5DccjoyN4BVPnzJG2X+eM+AsKwQ/G3/CUXnE605PjyF2HxwDlSCI01REYIfvvBpehVYlLw+PflYdbrLfGq29Z8WtNzGrtUDLMDCr35TG3wW2dkTKIt0IsF5Vp9Y+FuhpjPcnx/eXbqYG9dh5+OZ8kgFlOK9VMFKiNbLGnZ75PONqpeQMUV4I4169c/5GLjBsdTOJRw++NW9X+twAm9dba1Dnlq+kX8plwIE4I6F1vDO1PKH64CtqtdoFLMdn/P7x7aNjRzzvka3KDPD6X4COipLUDkY9BuGJPZAHhyNBYtfAfP9WAkkVKXRElJIOjY5xHJr/22j0v2txCw06Na734LLAVuXSCcvVaPskTM4QUaWx8AjLMTcQPLZV/fE57qrlzJr1nubgxOySkdqKCVGwY5duxv7g1LmP72Il/K1QCTcJCmPH5kmZgrCiaZIWJ4YtXffxIwILp+Id+0FDcE74D4z0pR/w4wQiNCvGPycMIHqxh7nIWfs8skxWtI0IWPxAaejI9ZVVmYrj6NftqJ9SamYU1indsnXxLOYzpChuJJGb/SXdMTHg3RL/SlvZb8iOttMwgzriRUkt4jTA6etPlUcPHdxuqOxT7jq25AxTQBce08UyJem0ZKYkFa4CTcYNd7D5YlswQFmDzlVRdKy7Zo=
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