Y5qHgmtna0Td/uNt1OD4XEsYu3pfGh8AhFxFomzsDDi8BOBM4+FmHzGGXw/VEzgBGieG33ydxp5Ztb68wV2eg3dQ/cHT8/dfdsXx+rKzeXxCSz2wgiF4Clh8qy+pV4AcH5/RFLym+lO3YdL56BoRBjZuR0tG234bCBeAjShahr6NHEi50GCSn8yFQysdEHIktZr1kPqJPKGVgmKpuLxEDiNw1R1/yTechQ1MaGILaYCQezGCVeW2xyJhrVl1eEAjTVz3OM3E9tVM4jrrIt96J9X2ps90ifKPfSeCGQlJ0eoGH0BJuZ3EMaLBKj3xg9u2OUWoOpndcFUQ4fYAa7myiZ3OcY+a8WCgNqkCIHoc9uMt3vxwH5EaOrDY0N74R2yCOSVPzK5g0PNENa5XA5E2m1lC6GQcql20LP/Zxm8DKk95hWYyD1/eq0LJrlZhMlnAwdJ6BjdNyYyWiBTOs5SwL0pAS7u5AoysG6qKfCVjg75fub3QVdlV9QTkx+UZkClx7E9JOtO8KR9Io6InFexJyz+1sKNXTuNGAGAWOF1lvfZVENW6TG+NuuI0uQXYBQhuQMX9NRUKgS+VOvOaovYutJlv6TwPExjeAcgdgFbPqe5NUXIeILip762Hu9TdltEo3YPH2DKUMxgs54/Fe36zTfvoeWJDB51ny5SJIl37ir4I6XBfdQcej19D/K0Rs+4f2ilv51tGqlRKo8v1W7OhiiwmNtxwS2bDieQeQLGJIAokmbOwRfikfrLZ3T2oa/DxB+CQ97AsOMmCm/qhYnK4YonUSF8Wrqs5OPz4fxn249tr04cXI9BlUiLRkSX/9JOFvTpr9L8Fjav6IUBpQPSgA/cpqzJdpRr25iWrMBoP6RTChPTGMA4ygFPFpTzbUyqsvYhmvYhP7TGDIA87QHLliSIVS77nG+VlNVqNfr1cD92/yRx0codVG+ui50hIblEDttPxxWldW4zDMedfR4/9s529g1lhV2pHtPg1yBTuYBBab+v5vvH+fheTduRFnD4ylo3LLwf+gki66NI9IM3DbtTqjrMppu5mRpHoTTsMpg1/Qz3WjEY7RRX8QyxBM9f1IAUxT8ts0oz/DaRXpQNwZTYLiGhuzao77CPZRo+F2tQiCibDGT9nKSNlZZtSSrYO1XbYOGRR7G3f7XF175Qa//jK+6eA6iAdargGob8tZs2VjsgW3hNOELwcQ6Zuo6CC/CjdtXefdIHYqliCOLyI8sRImyDZLtERrwR/lx28Vgvq4yWni9QXQnvhbykM6+jIDQ4XUyPjuGK7LSXmMU5ZISZwOCkaezAZb01KJRSTjiSLkJoHfCE9F+SadRuPFJHbf6y5py+2KPELiUBCfACdP6dW18sgWOX2wNnauE4=
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