EIK0BEKOn1TK/K5ZXwOzPMBrFpNmoHaiNV2KLxbRYFdu/mh1EpA08HMjIBnbvTOBcs8KfEf0DozMEHdaBK/xGIQgg6wXd8zxHeyUdEVbzUU+BQwfEwhD1Z60mN0iO9MxhAaHR++SsnqMYGnVdkMMyU2wws6qQXS+wybAhD98JG8136FrefxqBNTrbm/oIY+uxLWY3X7/bPXSM4E24qrah6PZSHspmc8WinFTY7UkUjj9btRPt+iObuk0gdmLOlPbpEyP5EZnZhsiwwtZnLRVAIbtvGXoSmsaJ578wCCd1Y0gBcnlBLWDJqP3hrpcQmSJMRWsmXY1eJJRCw7s+YjQkrhQYJyeNe0YF86ghFdgLJqhnsmKERFOxPHr9zO6EnN+VS9Pk9c5oVgSpN576qAYcs2zKeQ6HBJoGWtC1LdXy59MOtUKS3cx9Yy8TlSNNsib5iqZvvBOCGK7fgiEhtuXGP1MFgwGSx/s4yujht/iF1e1WnYPtN7vpCbZf48BCjiwg7N6WkyHDLx5CoE4WsX0/xXfCMcVUKBfrl/FpP94fjUvyUlyj+sUHpcSNWacTSaZEduI8gdba6Ek18MG8/+RV14A17YovNThbiJtOVYsBquIADALCXb53gR1fJX09ePeokBJhBl3+DuPo04OaMP7QJApOFZXpc50FXmMc87jzT03BKd/FJTN44kgGeZ4Q4P9MGxvMqJAyNnnQj1a51KVvxB6akqIVOYHj+9jt4THsnZSp81osXYP4jZhjRd63CYfixZ1rMu0tsv0y3OvBGUAMbeb3P9TRPKPKYyVVL8I6WnOtP/jRywF8BGM9INcXt9E39Us4GzdV72qqEotnRkxlMdLRDeJ4h0aqD0KnXaBnabBwdGrKvUBm3UC614snFhl2+Q7X1Sx4wt6W/HvJ3ysW1RhkU6JMkanhLkdeq7bAEL15I9Gferce1Hexw/Kzpvx+cjloVRe6FLgGXBZtVkJ/EHFeOTHWzKoh4lauzRjaiTicl+uagn3hh3CgOoTHZBruU9c8Uh2sOzXHA/Z7+icyYZib2BIed+UAFC8FJPi9PyNnJpL4CuK/eevT+e6gL/rOW0rLXqulp12P8eV4Ux1MYYnPUpAEuom0I47uPD93XEfyoOddLOIyFzf2Kl1JmC/VfAtRPJKJlA7OR/uh1uhEvEe9wse43tGuQLZAGiDItGVkekKrYhASqmH6sZNDrcgBAwAuFwqqYBlYc9xdkU4SZZJ61YWsBIApID2qmNGZgjDU5dlpBMg8YNnpDL/Zp2oZ/JF6Wx/fji964sD13Hicfko3/Arzk5DnPPokO40frpYYnaGFM3Kz2auhtNZo7V33pEN9W8cUI2aCtnCC6fVc8eVHKeQVY4aUEigNuc=
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