JPnQiX5TtOTXC1tYBI8y0nM0sMehyKaImaPbtrZ8IKgWF4oYRBZhJ0fhkw/ARqcS/jNQI9vUGC0Wwp8/+7ztG8dkjuxxzn3DdanY93hDcLV87bQjYn5ZYGQS3qtW1p6P9MaDbusZI+5SCgbo4HuMKiDFoaSNHkZrCSc2NjtOtAeked6vYRaeefkMVwk2ixVcHTb03fPlAinHrCa22SG2ZRx3LBDUmn4UU6KvQNhEHTTN4iRmSYCPg21vcyPV/OFWb5CQwZHjBwrjpTLhO7fIqo7Wu/vJyw7lvdq1ELsaP7fB5kaH/xL7aD1rpmzGq5eae0p4xUqwc6Rtm1XqkeY9LjpAdHOqvCb8zujHZ6ZkOeKB4FNri7tREgePNDj06E1AZ4uPEDyzJR3aueUlwtSQ9Gcf3LJQtiHOgNEAXM1eR5ucLDX5Xb+dRhq69Jtfu0f7jHHGT7+wMSdP6U9b7NT7h3CVRoto4rB+iV9jjccrBjnaZXHp2BVQFGT1EcroieOjHNYKFHH2bURj6HbqoFkTUA1MOyfu5nDE95+5KdzskRhNudn/LN5Pz4wuK8oxxOJqP94Lz9wieWNoHpPmes6548egcdGF+bClVhmN5jIhvFc2uV+Ymv5NSwkOmV8+cXkn0fUmZsB+euFNIU7CvzLWT+lB1MTxBp0XshNICevkcqLUx6wcWSn5fmyqv4ViWVuCarqLm7BzjnK1KPfWD4krz1tMQ9tVM6jDCrK6fWcmE90blQpOGJ8HgCuRPMoTD12uDyblIAmnwRRIi6rGuHbVaOZ7Uf6Cvy8OpiME3ziXCFlyAwfrI7P52dZxCjcunALpMSkj/TY5wbOAiXrS+N5p1hCMOrkyLyEWKKyPKvELhTzdnbXfOFjb4d7cHOztf8pZnaJNIwy/Ylt62xiePUTY9A6akc0xffk3vZMuFYbxe8AhhnyGoSnccWzfjxJLIf6etNljv8w+lcRp3r2QTL29x/pvjS1ZeXEHod98rNO3gPnNZhV9IaFYperAy7xBSjYhx0ULHSsqfRPNuPsTTRB9m+mwDm6+R8gWkhydu+g2UaV8LafoJZmnFrP8dUYSYknbyAejjbazufs4r3HNkA6NyNzNTS+RqwevPj6dhSpudXrNcRofVmVSQmz7oaxDWbCXD/2c8x9FvSNH4SquxWw1sOfTnJVcfEpJUR/K3PkSg/mesB4sZQ/bJzJMgcWB9SceTjq/WSzxRBs6Mqn24nwnfzA4kK0KLGVe7FfD4EQwTfRbkneazt1FF4xlKy4oKThOTvUQoGNA7Wz6CvSIjoztOxa2FmRjyzg3FOrPCt4cP1fWc3f6bzM5+21SzwI3NqQl0ZlxK8wftogxGHDwvO8iBwDJIDtYVUIRrlMZIRo=
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