BicXLI8MW9C7ftzlwzqQOIu8zHaMrNesEmnFkr1q8xEiffnUB4rl81nm4QAcVUQ5agnt9aiPQNVNbEipYCqU8JiGbTZh/zm1TJxL3m5vmy/GK8tz6GE+l1DlzS+F5xdDObaic2a5Mu9fZqkrBne8v2JmIVxlyXYSFVCHIP6vYk74uGTzOmhVKzW2hKX/Wk4ky66Au6v079zbOXGGi/GXh4adnSfwkc8Rq8ihGty2I80s7qAdaGqGPzFLWa/kRp0+pXlT2DkzucargCnqxGstXiBJdJJJAtZvZP6m0ycobJH9E5oqmnfm5z29Iwuis/p34CAWsUxttkrjQjpnDSBMJJLJE6xWuWRlEr5cBQwcfMRmLXCmVexdN7hKW5hQs25tGpqGhUNIT39+WElUp+LXPtNlnQj4ukGscnIJnhqLQVbKUEZWADZ9C+acHoPozi4xXnpFCRknOOJmy9X36/q37wF+7kIzv3S9QMmq+eSWspxJ6B2szv18BL4LKMQIl2qSeoQ9mikPTB6k6BFuUny38N91+Zb0ZxqszFE18qEmHDgtlhR0wqTFmFlt3yzO1NfXYUIOPIxcj6FkqR9ABSBdcavp7KIPgmSRd7FYZGTBkUwWG5CgPTrpu7hN8q3IGDBQCTe0DtdWFXt1dlHE7vdp5VmsBjE+gO6c4RTMEb22MDHA169hi7UQu3wnhyE4Z5RFCijwVYiZC3DMhu/LnHO2W6DOL0TZMhGv/MIxtFMDOE4zxzq6vvRUlhA7oRK2iZ1ZRji7Je7ekGXIKUV0g6B38jtGRB/CQsUAM3chG6igxtcuyBNxy0Di9XNLXYtBXwl00ydOHE7AJ9/BGJ1lv8enbrOtK70CYOYzmiTwuQV6saYB4z2mPlIPxjP6euqk4GKxBR5jA1uO4G+9wxk+a6bhO40utWDSiXzxMGdqx1m44mEobvGnsusMQftFIIlCwW7MdmSRXiNyAMnTjCeoLaUM2Kvk4j82v/WVZTJo9vSqU+tfUkPqNYzIC+mbB9dOQ4YooDn6FU7kNkFE3O5to3AMvGJvcANLHbn1MoebwNZRFHZXelMOcwlyt07aVPwlBgicrZNRgwDNcfRIp0cPZZ1tymImYzdBWx/4oQfYbIXUS3uWHTSk74Lt7qQqK9+47PL05cwwHHvm7+83y1lpXvD832XGhfyFFkKNDJi6mDsWI2BwOwfDQpwLD8x9w2Y5rb+GWPuQy0fjojlX49FuwdmckIf8HmRgTY9Q22zNZpfvoz38FVDcW7AebPyznYl0mncaNbPcQEJcJnbKAy0ojiUKpQiwaJzDctZxRRYLnBQE0W7tJe6XRS5xoliZ/sQQyKD4XywTiFD0Mw4lEXHq76ZHpZwmklFHrNRFGJrLX4o=
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