jZrmHmSoIaAqvANfcm0QPjYCjNsc14mnAq1mDemtMq3th7D9mUzswvU/ymiwbzZsFKkiTUV4meXUXYx1jU7BAAMVdeF6DLt1O/Yh56sjrNp7MLDKA30e0RUvnHd824EBXeUMx6i5tWLr2dpnhzWp0/T05MprfjSAk3uJBrgveYd3fWwaYh92uEJYrcfwKS88wBXZuvwtSlZoAtVL+YIbFk4pw6WjVOBvwfKIHSzBYFyVTK9RCZ2KXGQPm4t3DKhkd1pk08m1xV+r337Q91kfqSUNFW5Cz3QQqLdacfbiwuj5ZORfVQdfWgLO9WLd4HeLw6LemXr4rB1fs3e9POb6PEx2ZK319NBYM4OlOB7ywEbWgV55mz3NUWEXZRRqxeeQYnlO5wTSOpjeBgwPfMuqqjkZ+pPmbcV+EU3aeF6XubDj89XF6gUUObADoTx2GoCFz2FpUIo6zXkztxzbpgswO23CNJidxtrXImDE5WAb2G5k/Esyxi3IVBKclt2+KiZ/k2UY9yBrCVeytyB/lSqHTyb4QPexhl66NVJTNw6+AEUfwUukiidKvVgaRfy7yfSGF+staOCfqzTWCkG1tIOATy3JrWA++aWXC0SNUdCboX/OU9VoEjR2493ZpTZTnm1+Q5woNbkf8g61U0e6/arJ/zVVAUc60g7vqtIz97MyEpG9nSadhNBLBTUud1OAhU55waOfkwlmn6Q79OjMjZ0OSrS4NvRY17/kF9bEF33v+NN3DEV1CO6j6cEebFtH7MkDwFD1ACbd7j+PmI/Phk74BXgWRgZ7qfUtD2dS6ognrasVlj2OTluWOoOZF+6WhFquRbJQj39A6+TnqZBaUN6XFFDIhCXuZRSzpj4SpEqgQuBk6K2Q8QH73VT9pOnq7MLcnjPqOPEO1Wu4+m5GiDOO0a/FX3YLPBlLvEDZrsRVlWS6CycBenwU3FWgw8WL028uYoDXsDT1OKnU4bg71R2iI2HEWr+MjywOnPtnqP/NwAxURIXuFUdP9eohAZZhKIwX9xu/abyZndCZ62MVy4A8LI7tQHqgGazOqTYj5CQq7fYNogCL2rvTUvemV2oGvYnm18xnmqwj8Zsrpbkc1GNoNjB8k+fJ2O4YW9ps0Pw6Chi4X6Z1SNgrM4ey/goHB14mxbJOE6WmFiuRBWGEeHR14gC0mPfKHyT9F/zfXMZHg7UQ9b3jby9UtV+D+YvOwrlnaKlpnxRkHUvBgIhFAl9ZWreGmOOE4zd9Qd+Z1KfkytOcT46+LsUA3F9yqd9of80vs2VYSN94ZskSfiILob0pTFSJKsL97LDn2B6JyFjP0lpKQXybv6IlyOyA2FGR+hp0T7s1f1VoAZiN3ao8IoJSMpvrmnjaJZXD713NGYQ=
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