QfSf+ZulGP2sE8S2zIw54YBK3qkb2wKVB8ibIysjoPTszp9CVKXPg6TjYSyXnHH+MFInVOaKAGxUcpGJhQXDNvRvCZp6UbA3Mul1sab4Q4e6zB5ajgkKrZcUOlL4xhuKjZEw9cVfdqPlDMWngwtckryR06HesKJ1rmK4QpnFWjV/tHx3DsNbEmZvzwnHMbn4lB5x+B2uve2k2aJEILXaqlBIKHhrZ2Q6tWhsJwqFKW65wkScUaTHNvgOguM6GTVkuS/RasnySmHV4PtULKnxniWT31dn+2sXBDd0w8SoGlFbYYfSpLCMDX8BBvjT4gteEDcNO/bKf7x6xyMnYJiSNvYabRjsuL03zBMvnSYJKMJa/ZR086IhQE7okBmI81T91MHNRq1nd1Y/IOfpn9TUN31wdSb8RzbPDA67KesEzqNCzLPX3GQCQTL0ReImB5DFSVSQ5886vAMP85/vXB8wBx5vj+FWGuXTKf2rxbrwGHglniCjMMR4gQSOa7aPYj1DJW7s5qfwVAgCRDdcYQ6UNihIn/jsqPSkT71TivAafiKshs+q7V+4H+xGStZsaZTelpz/wvgAfXeXdCtKmAqMg2gEppD7Ty77RCwgDlmZ2isgpKqr9aL3VDwmBeuQ6IdxAfHWtVzolZzL87PJUAacFjTKuOUvq5Fsnw1WVho7MDr2Pr475UC8rqm3qI7UspU8fxoP/Gx+4S6bhuYLfAojvIPtRJ1B1FhFHzLGKJTn98NZc65UM76HQORQJZZ7ym0/Us0CUX0cd19Wbt86cqqAz/gmTJkzU22iPcfRirtWKQJ64y8NvPWCQjboy8BZNjPs/QjhbZzfU/rdHMEqQH9Gs+8Viu1sip7PT5sToqYTfFS+iGs4eCzwhsSZDSPJl2bX8yiAh254CO7Ytrflgy7+6vzA5u1MOg6FYWo4wOKCJM7w8lZQlW6h0ackNVgBTo2yEj7IncRyrOX2QYCVPiEbwPFCe63Xp9P9hw08WEP07gBeSQ3XLXe5tf+7wj5QPbp4s3lZd+KC7YoSfBUsjP0MR0vZVQEl5Ho8Z5eRwxZoJ1rWOh6HqxlhZr4DBoV7XPrCRQ4AKySPr3k81D49YF3JZBLZCIYwlbtaBsiKxWaszjvJMChLYbFpCo/bNNRkFW0xhWpSG4var/o3xTFtegFVpTy3lp3DF3aNN14sBGOSMfMMZ0pXFFKLrAU1wXQtYPeWnFr2LmNjER2po9/S+aYMcMLE4+ccqh3L1Ln1DakN9dmMB2UOM9SInh4XHBio0VjZAIUYm2i4OK5zzYQ+ht26cl2JGpKlnIqESF1wNMTFzx67Ii0wYWpwHKeL9tom3uaB2WD6Vw1+MMv2D2h3X28n2zSv3smbTK786zW5+I8=
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