TMr6jfOPUBNkaBbBYXv9aptv7eux5L+bkN5oIBGs/uGg8foQphOCNHrizejVjf0SFis0l0iqa+ez6lMjVpJa3IFcEeyLf84xm9i7uSdFHRmIwJ7zmIZU3jAR2pWgtg+vu9A6HqCQkyF190nSALDNciwpdeJeXrIth02NDNcZzAKdTK0frcqGuv7rTJrwD6pHoA5Nuo7unAJ4f/xfBL0MPX/qa8Rr38Yu1rwH30r+In+UHvF3R5SDRvcwOVAPQUYqyEEENp2WqqDftBGKc5i1Q9z2I7Mpp36BoVRx8NAoi5Jm/cNS2mVEv0sPekQ6jcp6kbudwTyOlgVbWxHFsT9/TLxyItEcNaRSXpw4y/nk5va7iI7dA/eNtfs6vG4YPxUQZyLjH1itodmo5OGxozDNKPtuwP7QzfYzIPgAFlIZrhs6y3rDILJS9CSQOnWVzP7OpiR5GVKwb3bFJ0mrw9rmDOeSUv7p9nzv0yypWH/8EVYEABB3uTuDDM04KWTX2P64lA/Hy/B6TDrDlJsO8EY60F/zX71ZdqdhJGQ1QBiizAm2vY3hSw8JPiwW9f1LHZgW0/vGe7bI4RgSpSuKEjm2XFrks6I/M3aKmvCb/oN4BLcIoPrXl6RrKLddxLf3hQiqrv6GY9orY6Fqh5dkQq2HMd0if/cY9C2vbJ1ZOYHqxc5mHPpXTjfjieBZsgppXISZPuvdHH/PZCaZt99NBM5rliCfD5K1mHykP/Bq5lNJIHn7gwcNp5GwX6LrkUlZCAtv5i076UuLvDVDYi5l78LDjEIzanVS8h43x+Exse41G+IEt/9R23HJG8cUo9+A+ljIjnw+kkVD17QidgoDfcfWXZhI4kn2o6J6o2HRM6b0u4yAEGw/YulhnVutT4Dib6jTAaGItWCso9KgmDGewieN7/Vm0n8zqjYgFKY1DBPQvvqMy2uo3ppOThji2hh0DH53bkQz7LrCD/YQoGVRnFLsi0nnUJwkRYAIGcvc4npD+OfGGh3Uj6EAC+K+nqmQwSnKH1Yhf38JhWqSEqDE8wGRZEzuue2/xP1BTuYPp7BbAfgX/vC3N7bLCvOFtw/R+GLiwHsI4XUG4VAjpcTf4UD8Oi+Kxzp7SHPOsCpTRhJyHR14pN6hJnrYd7+Zl7lPoIMDIp0KQ9W3t33ka0c9Y4ls13yEzdN4GRYiZVGNNtxHuQkh1PEFWj+Ld5Lv/wbjshVykteqVn4mk6dOGOiOuwukT5FY92UGUzjFx+oqK5tHnx49QSHrr9tQ7wNSlOsJ8rIq2DozelO5lR27AcyiXkGZ7LZbPGf7eJsm6F89BrN+R1FloxV5TkHp4165tWobrx249Umv5Kh8x1p7Ozrz4WfcdsbMkQ0/HBVqA6QZ8PU=
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