WEcyXAOCYhMGVsLsV/uCkLup91zzWHJatHuV1Ni2Sv2V9pXjTy1u+ZHg3lQQELijmleH9xC8OqruZlE5hSqwWP8W2SGg7s6CnPuEHGGug1dC7l8HPXyoyhzP/2KFal628SRiYqzDdXe2qj/pktR2nrO7cLO2T8xyXzW/vfgiW1gBzltJ9bvXBa7cKTYbwF2m7jZtZJ0ABgmMpu2atL/ZLIKu6XFmCiRbODq95r8xZSS68l6M92FOYAJwXT40HuPRTVCRLxyd7xWqpWyeEeLuP3BzouaFbbuiPGP+fKGvRBGpdN3BVACVv/gBA3/s52WqbC0BLF48iiD7MQtn3/FmTdDmD1doZnEKXIZQHVmpbq2RYhYASHtQ/7QMzHTJm03xLnNTKKmfjVu5zmeu2RbhzLnkzHP7PRQ4tus5ISPJLawQIf2uYerVwyw9eHtLatf3J3PlmMJuBFk+HQcc46rV0C+DnjHGlGOjuw/gr8i3/yxjLfo9aFcbMi7vcAGbcCmUs/sCMrIG1EiAejm83euttAku/KaznURea8YyMFukhb9VJrLXvtn2dZ6Ocnq4/UKZiHn0cdWOHnAQoM6PbFprCPPVqiD7U9mC1wZHYcPBzHzd2qH5c+Ipq4I0DlQGv5BDPVRehJYNFMCceP9DJKzeAFIV6QG03b2iCKR6iEpG1D8a4QXzqYsCDmIxkXsDh2W0fWJXyAy0khFjcVl4IXiKCS5ukmPB4iYe1/oXM4Mwge3O2deV46GnT29wxIWiQQ/ocTVI/YmNpCZHoDlJrt57b6+99NQ0E2RZPnir/3es1Uyte1n12G5PIDNGZAdqAmemCV/+f5/i4M4qugejmAzx4BP/lvwGQfTclSnMDduGjruobobec6miczhrMLZ3mgcWT60jtMG8hSMQMFQxA8imdh0j3Ft2kjpg633trDginHuDg1bjXGzjm9/Irk1vKJ1tChyqrBvDcw1G3zqX/HdeRu4Zng4yeVdJFlZJq1cj5C2miDLtnrIOR0kmUgnhSG5y7Ybml2vCXu4bWfUDEQ3mLUv/KVebnAGddidnLpvYpnikvHrcSunwl0X3To7BJpnV7Pac+0ykLX/X0HG+m8QL3HJTy8X1zpvxwgnbuK0QBSqtXeLWNvZnR0DvgH52Tv91wlem7XwtF+ZFj4UlYPgxjgaZFM3zpTbbg1cRbJgBtpc40+E86TupVXEoi2hXqA+mvxBXaE8evfv6rflhDymKHCwXqXyj/xxNxXkDhfv6EHefT4wtac0B/NqutxttKLAg3L7qEDGlUAyfYpbt54ykoE06jQt7JNHeFUnIpX58rZBwUnIRPaoF69IgpHL1mba6qGGoWULLU/HIICw+7fdoGACkH2lZ/oW6lrnnZjQ=
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