DhP/RWuN+CDmVEbxBofziBsEQKAEq6IDrklytpflNaIC1idJIwNv4EU+rH6qTnrU6E3bkUDyTaHHBmpBz5Dm6fybEMWawxinsTFhYs1keFLevZoLggzq/CNtTSnxjihfjQ2eZYVuhZsOPYfuiHj1PSAF0jmQ6xgoE6+idO6bFJ2M7lomdWrFqL2dKhuK2DSi54vWeUetjDhWNH+ZOn2vNHpLjcGddcHDj/6a3NXTb1mbK1v2EQ5usqgC/zZOSIDKLEXjS166Y0rT/o6H/LyLKf8ORr/8JFqUOyt1cRpGxk/nRIJR8ft4phhBnY+c6bTJhXJM6RfiVyJVI+9oNU9O/V0emyaKQ5zl/QepCrqIam1tUUO4tCS0cM4SmFzEGV6w5XY5CBcsqReXohfebNfvSULI7b0PlQ8DgCVpmuSIgCKWCw1OaV7IhMi//8FMaBbdtHwnAjscSnfp8+0Wnlk3w4Gnv0a7RxFDvTz9LMV5B/m6uDOpRmnaSffITBOIkwbfAPQDz/uXEcwb2Y+pPHiS0CKZFafylOkpM1fMrunM8sa4hpR938q9P77z1cMWUvoNnkHRTB0h7ciaoxKCDYLszigpIqTTe27lCuZdnTkNb7zd5ICN1vMPvoRd8oyCtdNXuoDyqvzvlnj/S1tS0AABxVDhAdJ2KNX558VU+hwtKik5sDCti0GbPscVN2RqLNfTSIipK6FAOvj0bRdC4iRj99iXIKFzzWmDW817/CQxDVv8lsr3kjyaCByukCBMnm0BOWtKVt4kmkl+N5fHWAQJ70SnCHmf12pg8GW6mOG7biL/mt1ysBkilXVnlP8GJpngLDVeJ3BfztIN1ewo/0gnd5ttbgNLhaRDhtrNQM97FuTCJDwccetorhIoctfHNpxdVfDvgzBBvjDN1G77elPtmmPBpRruF5U4Y2vdYNxVblEzujrj+SYTBocHJP+2qsemxr25s0iripECuObmGWkuVGSlvpIcwjdd0Q5QLoS5dpu3XaTiTF42R0Dvyc7VDb/VkUTJn/Abo6vL7FuwwORBugLKOXrr+WKXUHayId08IBNIuX0+c82WehL2wHavcCJpIrycm6wtzUxolc/YnSSras2VgOfb67TXiFd3LwJ6F4v8IZcfVUN2ZlG3CHWOUxI7Mjx2LthbdD/pZGva9sky8vk8upeNsiXM3OY7lhB/sNWQtoiAMJGkoP3Epm7kGdDRlPSeRl5oRo7wbI8BCqbEbHRoNi+5IskjZX8QKgq9z8m+4yPry3mIYOVX5z9engUq4eAZO+Btv/v09i6VFCFWyZPVuv3SC9qf3XDAf5bR9cjJYVWAyzrj4tHPshKURWkbkKdKxJdKkmDaTA0V5Cij/0HU7QnusriuLrFYKlc=
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