THo6KagTGBRcmO7BLxAtsSqgF/U+NlyZCX29YSRyeISbBkSjxky8onZ8YAEpGSHlghbn/j1cG/k6dIKwC6Kq9H/qIPPgj/aRN3PGttbJW+7IEgKxnLf06q+oKfQkiHAPaNZWzxS+cB0IeiDmgiwekjJASeAJvljBM8jjdqMCRgS1YDIVonGDp8lGCD8d1PFOUjZMAIShjVmOkt3pLvh9SBd69ZFOmHYjmXLA+H/we7kekkKVPizeRgEUCXu7joygGQDdih2YpqsoM4o46axHsBeEJqC//C78cQyK5fX2sE0pZBIX/juq0+XxlTVC0j9kEf1dlMgmKwtolSy/Ph7LxFw6wveT4E5Pt2XtJcd1y7SSSmvZjxs2T0urkSEDqywtsyB1CiXYmDelNugRplgGqU2PAWFtHadKfAS9kLOSxjJCCJV0ZxiMiJdshJeIcsfx7OSRfI7EUQ16cAzVjsJom+sraZvxRapul8ckKOWqbxLyV3UbAGgLIn//8IE1vhliWfHg6avnWYJoUK9AcLoj8417QKpxhOelGjho8YM2Y1NOAzW+0EH3mkFpzgQTH8bS9E0nbQQ+P5E9M8/IklrhBRi5toDjf8tTQa75X1Eg9VKYgjMZssKGf5ZEzEckfrZhlY3J6k13et78fRipPykY+++Y+c0hlOfuybUOj7woTabN0Uv6AxnNiEZJ6csTVNjaprF2Y6SP3DUqm9qvJtIpgveblzzsbVEdPGhHVEWBav6E5szulSvLpQo86A3v1CAxz/c3TrI1DuaaQ1AAzZ5UvYZp4XqLD0k732coZkmgWa9H8GNdekLbXnahKhGib2lAEXdZ+Wbzn5SvuA3UkO9Gbu7Lw26BaZI8CTNLy0Nd5D76IQ1cWP2HG47BXPNm9Y2FpGsw5cV2uGpY+023LJMQ8XTt84f0fu00w2aCCcFlDz1ohvH7ggaff0xz8ZQcpSs30Rhk/ztvm2mJpbSrWGGNeLPn2viyhveI0fTEhHk1rvND8KAWIH7cBKEXp95kJp1twMj1oNhogeAh/V/OpK96cISen5XjXUEcz9PC5HRHUCfChkaz4/XLYfPxhWXtgrVwLJRG5DyjWwngNBIIRh81qjaKnNwOwXTXKBgvC5w15AVJbWKggLnThXZ+nLT723Tt+X19r5HQJ2zK5VX9nhIhKKgi2VynHTbLcaiSlhwlbxkxSewJf5Hnixba6fXxBUP9752dHc8NGVLjtfLbeRP3+ID/9iL2tG9pP0YRYjWtSY/tLDQQVD8StzY+zoSCKfoVYxnvQdQ9UxjTMk5Yk3/ptDn0VNVzwMM5eCZDkFvGWRwvtFRMjFYuAvqNdCaSFaIWaKGaIXNou5n0X2fbCU6CQthbFPuPiwrrmo+2imk=
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