OKacrMUgM6E/aX10F9xoEzHcyJKFVf0G8YUuqOt6FwsCS4EnSv2pAjkKjzK8H40F0leeJvhEpYBLcS0rZUVk3hA56UnWJsKArYNWaIgyXoOZ4p43ERYLp0rQTHJiu8iHxrC/obPpieUBY0/YRxiHxk7lraQs+1Wx2ItSm96Hwq32arhNtobG7Ipc0RMJ3N311amwn31HXDYhmBwiEOsFhH5i7ppX/PWx2YOQPdZYuf1d5HBCnJ3fmnWV/Y1yvhypduwN86tQW3uoKK95kSp2X6LqebSNsUqe1CD3Sw+rq1MouKdpYB5t4ad47XSpwOuZjRa6DxLNnLlxv18GRKaysZntaSZl6LeA3yRPNmv4h41yTTRhk0VbIMb07SCXY88oRSAyAPHkJHaSboxGWG53WrRQB/OLIKpxGXC35LJ/FdFyoo+Kf/ASEliTr3HpL340SV2dW9Glqj8U81OtYrSqGg2nfNpdHAHgcHI4qii8Lw8cvXhu9/ibxmdwNJ4fPsoFYCvbg3agwTNdM8KLP8XezlcHZ1YVjWya4G+qE8MXMh7d9tIPc3SbWTwoHeRJiU7NTI6qxiPH//i57NAESsxLkKoNBctIqSshqIueHqPweg2n0yh2/Wjm2UeTJ8xtyJIicipWReVeQXfKeUCy0xTDzFDJdRav0ae276k1PLcw8hC8gVmnhTu97ZxSsN0S0rw1QFZiIntbhmURSVx6eQgrWHqY9jbLru+Ox7wE/ubiWoJvVhhEqv7bKcBkbtqoSJSQEyQkkaEpISSrWp3vyJUMqcgTH67A72rdvHVWrRq2ArF+oqIqNo6LukVyvJOlCu4CkrZaRY9dzVu2tP/DYFd3+DPauUvrZjMd7xJUPSb8vb4Q2cOrS1zRSePEloXhxfcxHrriLWFmzyOkYvP9CeU3hpOSPzH+/0c/Xvw+h6AOpfB3GrDkUmsFWxfdimiPllH/3zkIxLIrb95imjTTX1zdPrtEKE2Q+bDjiDFrwcMGaNS0L35hkwcPRCO8Rn+mnvT4Xf5cai/2BzPVN5vvEiJvCy5QWiW4kzZ2NEPR7p+2yv92CgQq4kGQRGoH0SsoWX6bHJH1hRsg15nS9ZHEH8XfBajqXvN3iwnRw1PltgeUydeE4Y13aWPWDjWnQn3HuPQ0PndppGqO2YEurSN+7KL5MtCvVMXIGJzBtSwm91Ww0a1+7NoZJ9eNL6BuwI932WrjdHLjmQzUek0oYPWzoCzo2wcCLg5VzkIwtGdmBRBdpdnvGJHJwgoml7sh9dY148C6RWrqoEUpRUIIzlgf1ylXfa4zVX8pd22pJdY8Mu02TZ6wMzfuvRAw17TWZZFF92PXz5zgP352jc5A4ENQTFl2+5T/3NJACams37U8yks=
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