8J4I5aKEuH06IGS7DuUzQZg/qBjUGLxxGtHFmYO0NVZN2mXG2rP4gj5chgfv1uGYNOi34Knw/t9pIjA/l/UsV/IFiHa5FCUKkn750CBVs/0QjEbcajJIk1+Q484CtRGxxlZM5rEk1Y+7qMdPwXVgWvMLVXAbPgMk/iuUcX8uYJmJ68tGiLfrItmQZWJGIyNx0t8nuWAD9+CntOz7Tj0JGKhMT6vz0LXXrIF992B3rveHabr0WRHp3Ma9GZ7C6Be3MQTzpXE1rm4o8whDWM8XiGD4F4+PGftNSsO8ZRwarqZ0Yoa77c5abrZQjRYft/8uHjoPN+0qKBL/4I1cdCSIsSV59VvbUDggUYi/QnoPq9xrH1JL3MpP9mLEYkKvfPD0YaiHxGz0jUk2GQ6sG977utn0a/RNyIkKMMz4Ro3b9OP3ei2NEdvyfCt+emJ8l2YFu1P7HXfCC6aXMC8Qap/M5upPXFFhZBUs8zJsirWOgjmzd1gtqrqB7+XG//z4hNE9y4PdTmLnRPqPQQ0JSUXPqEYrccJCzh9Sh0rZ2HU8WIuH7sGd9U8TbfiY89FDHLMi9q16ZSWxjpzz9ZW+2tKHqsxFchInADBV+Sk5OE2YIH6m/X/dfKT15ujMncAxFG/Y4gbnU0yb3f9E8k60C+n8y9cjJkp9u3mPO0HNPZ5OLWLUj0MvNgCWRVFOktIgTqQhcD3qBaQOH94Hy1mu8kR0MnQPsopGt/C2zXIkOk3D4a9q0KfPvZow7+WLFAeK5BDI/TV0rIRT7g5mBJAnlu3hdlbXHKXDAMtrftYOgn7r28HqU7Gb2htBvztYkvgYydSpjdhREMVS8ymZfyAQj2MGYjSWYx1kwPGp+gp2OPqzG2uWp9Dx43g2xjGw0n3eca4UeSqkNKN/XW0br0EL+UPmMbgMybf5ZAQMJXuZJf97rZnFC37feC5NSXm6nEHpX3jDGe/HujHYN6GzSOffX6ewcRN7nbl5N4Tt/9742v+Z7Ob14hX7dod4fcoJ9wi44bTMenT/9OxbA8LxEGjKtbXdtwqs5awEeA66oSzwA87bMEiQaghjvfeD6MXBFNDVMIzoTyB67XhSCxvMDLkAJ6cHdapHvC7/n8kzFPqwEdhRpx5O4WDQ+gQ8q0PIB/3u015LkZZSXmGYrKTFkd1G/GxCVllB5EwK1VXNfZuhwjWPog6dR+7GrrUQ7sMMG99TOeAchJSeruLV64nyrl01SZs5au4eql3dPN+4nIsW4uOqiyflTOszwzqR3+fBtlsDQgQodDE8JR0K4lGcxFt7AbTA7vZpYiqDDraD/APixVKnSrDVFWaxVen2AaraQ9nkNFaV4Yb+LpcNgLkxPkuSeKgKK2+AzL/BdL8FRQCn3gk=
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