gZvX5xSO+bx3Vo+n99aCeahoux7F8+oDwD7BMsmOs9MCi5d/fEdjW6S38mLGjX8r1IND30lQ5evwKQTDaQg4iYThDnQFuvwQMZhfCu2SHpSH/BpwQHhWSUGllmPTxINviQO1wyByp8tdH4fpS94iO9Wv2La/bdw/GoOhHChk7d+QXKJEPlWRf4lWDQop159S01hp6DQ58nLPXpY6ThLqNDs3OsTeyvX/fx4KYy28UsYuuXxClqo4CykyT+Ucpow2fA4ba3orAXomvMIZuoZPrquTA+L9e4ZRCtM+q/FmWRIft5c5X9wZj0SdJCFrIwsfTUPlDByPIZ6+byBhiNW7qTOrSSfdtiUdRl463Ki3LlV0VyWaV3jSaqI8IMLFsmi0gLVjNxDUg2n8LLlLo8h3/qVvdrYthw83KbUoVM2Ho0ytVKC+frD9eNIjU7AtIRRcIfWFG+AYzg7aWqzpVkk9mZ9iRX9z3KQWITJrPoRSTc2vdUTBmQI7l2LBLI5N1FjevGyaQBrC7d7wosyq3P+vApuT7yr/sae2HUO39kiTD1t18xmJrHiRYPWqaE7tacXu884gDa0axAAx4yDc2GVXdHFemI4l9Gp4clYFcOPj58uEkOZIiHKNlSYu9kDNqP2zh88ZEDu5zcUSN+ZzrY3n+rG3OY2a6fTMywp9m0g+u/JYSDpKNs4iMxechnTvRezyZdxkoX7izSu6nOHtLQDumoTaxRvdJxA1MBNERd9wb/oplbBmVyqriULAORVFRKLPx7RjSPT+On5ML3CEGGJ6BBO2xDazT7+zQrUjU1r4yNgfm/kFH8roUWETdzem3i8F/QRffMbA7fdmY6npASEeVv7HtnHsC8NHxF4u1+MOVhk6jJ88923mO5HZ5AaktSMgEsy25RCS0PX1Cd5dRedz6FNP97RLDkJeu7E2nUTowRejSViJj5LqY230jzxU8LVoN6/m8rtLuaUPAuBwVM/CjekiYaBCBLS8ctTLfSqdObJbFWw2LnnM4j69BahQTGZ017vV51/kQKJ9a1Z8RQA6SuKLCWBT8kI3iwDoa3GhumCFsmjqmPCWc2pIsmJNZsRe2Oe44jGMLoNmo7s37jB3/Gbl3U+cV2e4iLZhnlnzIfAzkNGJcsHUzzAsMKH2ueoYpET+gYQPdwd/S5DTxBq3ZW28vvxr2ooOCnoVpwTDflMqlRLIkcaIAlgoe+idcHyntNa93/Jqqm5i5UX4maj/Co5XN2UEED8zJhmBjglvbWZmh0oFituyT8lkoT/tCDbEA3oF7jRTfllm5KnHuvOn/d1i5LJQJ2EHC61FqFK3QZ3N6LZPA+PcJBgZ4aYkLzNv5DI+HzjfLTLbHOfrt2SP6WCmW1mnfOiiQYLRJ0g=
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