vcg45A6Bbs3DsFXnzMy8KBSyHDoiSYTY1Xb0aX24nrKaE779d94Twl7NEHRANttr+EGa20dt8gWyxUrjRZb6i5ZsKYCAjkr4XP95O2KBLTWvIpiZg3JOtsgIcyxtAtcC/sGubBfMV3UBnWLFxMeMfnJpHpcMqDBoMIZGm6jm7cWSEtuufc2g1q4+75wo+9JKMpY8ESqu6QtSci2d52y9U9XYoX6Dl3kLhsVCZu6gfy4odbTDrTRbT+Rwx8194YYSyRK4+w5cvkbxs75UvCtQtbC9MjO8/X19U4h5L8XGu0dm1/mBoFDYF+Gusvxukc9znBJJzh2FfrL7A5XxpobOK46+WoKAIJAN+Xu9SWOHd5c8vHDX4hzRvvDu4hA+LiFp6Nx32JhzuZG8kfY6cYIPaH+LUnMQ3Ag4qROahbk3kG/trUJdqJUSo7JwAuLrekVpbHB5x580BpBReDHj6c740psiOtWG0sr0JRy/IOxr1fpL1vQfc4Icbm6Eg2xOTE6aBx4j64SJTQvB0vC8JQzi4TMMhboHWbi2iNzN/8TUdz/w0ikr5niosI824oImeOeuXa9VeoGBXhGgYC9UzHQhXY8aU9YsC/2ZmC2iM8TDwnE3UNzOong6PKJagBvUd85HQaTVPWFoBDTLZoiXSgTSM3iR8byio/nQNuHn1ONIxZRztJQbsC/DKMkwv3GmeaJ0/gmWQSLtRIOz+J6iF02jf36ku3gRPuWk0aav1E02TfQcBfCrCwPtD69yrZUZKJInqnVe9zqh9vHovsgBcwJfnz7/a7Fd8MxMCz8GPFQr9yX3ptouRzLvzy4EgdBSEkn/XttnONzxBswnURuTR72Mk3PpB8U+HhI2GpfCeekyKrsikPbbcHuVpeUKyFuS8cG5zFj/gu0qQqubhS8bsNiS37WggPKt27wq5BZCE+6+daAn3wiRhqh/CtlFc1sW3zw0eywwk4FkEsNe6MYgq6pGfhyLNXhGc/wYgAkjpYiHdI8g+e47fNSRsZ4vqvRM5ThGQIPIrQJw/7dhpC3pUc7PzC96KlpxUl6wBxn3W0EQ3nMm8OTmSDmLwenFlTRyYC8+02KMi+b63kQJLeRqMqCAxkyUbgQbOG0XXKntR8AT45bY4TcZ/oMA2Zago2EEDtwrDtb/8lxsparD72gH01HdUPK/fk2pYu4zfSu0ht7DduHKbcHYEi97md9uh0FSY05epCZDyNrG8IStkXgyPEx5t2zrWxW/Os4T/Jkmxpb6alC2nxfGJfaBxocGOGZ1lzWzrs+nXxcH+ktDCCJpJAbYg+WpmM/NES8eIV31QzNYjZrZrSsM5h3w3+93TS+tbVd5j6smLo9kSyQAg8+op/KVj/F4KtCTjztSl9ofc2Q=
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