Z4yz7asg3u0QAVxAm5KEbq8x3hRVLji+tx+EpgyIVXe8S5lQPhPxfGrAc30t/GNj5oJPWAq0nXe7A9rAdsk91QHLP1r2cZNFy9N5dRhmy+hWe5ef1MXFxi7aWOZwiG9iLoZjKqH4t0H5c/4fNHbyfhOLKgOFOJDZ5ULdukUlaN9cWZqEFhDCzAGVcH8dhfvXAqULuRsVtF9cViUh7JokOfd0JLpaClFgH9bXGzLao8RWK468PvkU9vAF1gRNbYMsgKvr8hNNgE890zeYCP/ixh2lfG0TYqm7eyrMkMPmCZyDYpwpNrZ+2J88opOAYOgM2E5zEPkssmeGaN+AnutEEG9pcw6l+NRqaEcH2lfLs0uyi5pMzY9Ssm11p9mNHd2I7z2HBNeCQ42HVkqlspjSSQLoD5eck+slokSKxncxAPq0Etm+CDPUMrMQKcDmLo+9rAG0JYJ+saX8O/lMsjXTlltG05xtXlDg84GuyeLnJgUZWig1ydfioFSWlyr6X03lmWVzdukOks36O35XdYb/vyUM3kNZ75FXo34J888IcxWupJfqMg30tsqjxQb4zbTANfkWMl8atS+0OjNS2np7MZcT9gjQ9S2jt+LiE9bVaR01vqz6PpmvU/9JV45Zlbt+BgTTArzMsyEymeJIwPyuIKJ0aqHwnvcdga/5UDRJ5VBOvN6Qw7699rQQ6VxZ8GZLIowSTTiDCZZz+mdJvcbQROZFa/KoINbTgS7mRjUTgRvUudP1Fc5ssVwKS3Fk6xkAXLfg52jmuMpxIA3DgMOjDJNMlrrZBYO3r02WgWf1piG+m5F7cy+QedEMEeip2Fvq6bzLr3KHeYFnyjzWnR+DRAeLiLVj0memPjvAf9QolfV+sSoR/YMNbBU5kCPefN+yjktbSIDjYM5us6ywlhI/j6fSx8iIMISF0igN7Xs5EegIi5a9/2vO1OPInAcJ8GTg1X5Wmn/Rl6PHrrp85cQzc+EXLSRDac5MddkiHrKIZE0v3fMlu/VDyJ7CL0UV/5zdrnKXyymgKgKIXKzvzitAbghFMBX8qM8pqLWf29AK6KzoXELBw5xud4UNDieT8DVTJtazWYb846IUmm1OtSoarTn2kIZl/3rQt8PGpB73RLyTxy6mQIM8t6u6U/SDPjbqxLa7GqhM+axFAU22fNwId0qR/ja9BRiw0XoyvkX5mWD1sszkd4VsDyrh5yFsPw8WmOw1Wa+gvB90XYLP1h788v1KkrwJVH3Vbb9EJeQdUMvR20FKBhYT0MEgktarvsqPc7OmIBBPZqRffvLb8tDNzpLl/34G7zoK3pOeYWT1uzrJXebGkTb5xgkv+WvD2GabHJ4qGJGLVofjCG6ryKtiAErzQaMhs2TtmjT468C5itM2pa2kbMBrjAOi/r3YQYE6yf0puDGH0fOsEznK+76peenag4C18smCnx2hg7JdPdrSROI56bN8tut1QXsW+n1aIAthoaFQGx8jjUpj7lSC0Yz9thdU6y/32YdYhuvPoa6rRAxNHuIJKO9J+t2mw9kEJchSbxfNCU4E85HVnyZqUZqbAUziuxqIT6eXsDuYS8klQ8ySXaMo3Rx3sl+gBFdLlE0J4jJ/aMdADpDv8D8FwPAiHFU4k6Sa74gQZA8CyyjhK/PyChkf2O/F75wg8qa0CB6OPRKfUyOQNv9rFcoXrrG+qt7S8rOJlzYGWsoiB/ZwCC2ancUh0U7+4Oo=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100