5/k4KcaGbOEl2SmlvAPl9LdmKRbNY8VBrAniPciWjfLiN8mfOwzZW6/st5PPwdUkZXlIlsD3GsnLcbTeEMQ0ucScjqw4Pege3NRJjxfc2yP+2DLh89hiw7GuJ3hyWxONcha4romWlyT/4sG2URhhjuHpeuco1qHYBbG/IqAPT/prGclnlYtj0MY70e0mDxXdh866DbNT/HwOJGX2msK51CHrfJsP2FjyrX7zlZBEqfBwg7mpx0S4hCHA7HLL6ED9CdYkFSIAg0YmNrQOrkV5f36o68cmd4AQ1/3ctzbTTwAFOgzXMwmnBFgwdObsYa9aiDaEgxNz4eFgskEbLSZ8SRWUeT7ymSF64CXbREdSZHpW2mf6sUw32bmT7Pi5oBxy+5iFVX/EYzWoounViZ7r5G/wG/fX00UGnG6zOrCsdPaD6Rdk48KnCWlOKn7/DZfMeD9gvFqx8saF/ImUTMdscS/OrEDChzyncZ+Z0BgbvjPNySD3xiY3vzZ4K/fZxXf2gAlo6zOd7jPnzrBtXVmShQP1RS/L27//R9oIoI2L80xKLrcgk09XCpg3gN163Si6fDebJNEG3Egcyl+MJXBjImEuRZNe3cK0tnuOBn1hzUkSmAVzY+Z2VhiWYzpkbstIsRoDavugUVuMv+4Nq7TLOBbqdzG8Bf6USK7XLxuP0U1vqc3e7UL6qV8zVxFlLgIEIChtxfS8/s+vmX1JcOyDNFiFzzbP++WkLdPIK1hNzuwFQHpDBsT3OyWQGlZJoymCZ5N74CezSNeehJscJ5t4WBoMoL8sgQO8BBTkl1p8mUAgPBPIISDgrrlXWeAJwVz6a1Zfed62euirKTdW93z07Tp3vTuCZy2zYKXeWwvAE3ShSCvsLR2cJBJhaJcMmrdAAMx9O5KbhgWqHCARQ8A8usT5hoph2xXt6Fj4Uuj3RR5QoJ2A1kngqxtzq927pgCstgrQxd6xmDmy1ds7LMg+ufHSVPOOApqnRMFLQFO4l2sFYI4L0F0mhC5AvC6DU838mI3RQUmERgX4mcMGaTb4Ha6LoAANQ7YrKS2JrP01WuNrltMA4pcVC2qaS1QaqA9UB758/RcXCptPXXna2BbE7WcfOii01pfM9KLufWlIC1t5jbZAGf6TGlncdimPzrp/qwLCiwDe9/jZBGxU7CtMAPpCVel7HxVWYgalx2tnAlahJ16jd1FPRIfB72V4HfkBnS9R1hO8D/lQHAd1Mkq0F931QaBboytlMbtfKYKMZFZS+ZzPWiTYaQ9orehR00a0q+cqPQWTVZAsCJMF9oU2Bvm7AAfjX/AZie4lh42jVD/A98f1MXXE95LToaGJ54wuBChxn8wBr9e69BVGMTYfCNAFeyUeFPvmFtxuKNM=
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