xs7q2oFSYbQGTa9w0IVLcvz0/6tZQ/UbsWUy/FHNwr5XA2tefyd2kKDg7U6881kL9dTn1RqElTcFlVgAOpvJrR+y67VAqSTNz0CJA+49TqSHvk7m0U/16LWJCEyTr/U3G9PrvJkRaIwJ/lsONyGOrkCYed9hlESub2DEEEtZiRHAbCbNkOVT08Rt89AS+yrieaePWV4Ep4yMbvtQ9Ccp195MsUbhRxP6w57PbfccHm3CotRtiyobNJuuEaV8xb/M8FpLF0iYTtwM3MgFjhqJoatl+J9NsFcMslcveDd4HFh3SDfwTfgaCSeBMVgv83d4xsB6HhawUifTraSnRJux1GWLlcHatl2pkdRyCCS8O+5Aa2NXHtUT195N4pr+J8sI9qGkBkHhv3JTHSC3FOTdsmCViq4GNTI+mY1RTLFfVkjIVn7Fp+YydsdPZ74gRBeM47epvifJ/bZyljC6RnGNAu9OIFU2R9m2nQMvykT/sXG8Zcz5Tdc5GMqzrbGFeN0LsdvYoz87pLNzJw73OD3fB8B058LdpeuZTgiPFLeIfzbDL4I8e5K+EW9xsnDGV/k+0LVQhIx6r2I/8h5CUYnfcRUaIOz2y0rj4HFTlrAKygzrViusJvGiCBppDFvICO2+PyYbGVfsJc+VfDneJFzAhe+RAMRka1ZtQPIt3S5C7uWJGo6jLR7qNQD5V08qE+45KLEuLTJ9kXoWOjNfJNtV1HMiWH0PLvds8AEL48/ZSW5i2FKT20EXMDGux7MQPeyZPEXXTWX6tqOwXMvqKOPRUV8mFAMiG8IkdxP4k2M6aE4Km/AHxRmuOyLk4oDg7Ss6cvP7DzaIXBKJ+Rgf2D+9JBulsd38jS2xlZ1c0KfR8qFHohY0unLcFH38aKsGDi9QMrBDPn1jGaagoRFzSltpAHGfBnH/Xjwi3MGCQgvcjnnOqd8kJVGEBMcvqJ+g3wjMjFVAYSYSKLO/gJjMJVKPnBl2aCXYjI5G1OG1uxC1rUHNsAD837YmWKO9e+tnpdl+ZGPuHNYHatIE8MggB/Pxh6qah7c02FjlSFPrLlD1H1vX/plJsh01EUWxLfMfItICbvVQq4TZYycLr4Pp4MbduYCN75vzf5yW8AawPAuu7ufSVCVyKg5Mn0yRMW/QDuh1fxSbn4A+Ktb+FpdqnJw3g/9EOwWAr+kOy203ENPm6tbXtmErkgHbBRXxO2IORfije3PMfAAslNYXpvWvDOovJ1hy5H04t34XvnJBXObEQM3gdxSKc8VtmQKGIpO3I9V72vRg2UNyFpp18MKwDBe4/9Le2t/Or7+2X6Qg2GHOUFANAfsUJBNxcpmPNmXd9uespOzzmUisajYjhPcdh6Q8bRifY3L7hmbMpNbg1Ow=
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