hvT74q9TbhiY381igmKaNuyQJZ2yXSfO1HevJ7oqkeW3Zo8LuEQs4vedFf6y2XX9Hhq2p3MpO0N6XgFithTXypFGNvq4fcWehQTFUnwuSqpHSOH8oxuCyFx+iI1mC2IJFSmw2JU7bjlGBDVlb+91ymIDeBPdaT+dikF0gHZ1RIqeHfRLDCCTYsjM870FA349YiXUjbC/M0Sb+tl2B6HKgp5Kut/E0RDZTIINcyBoQJZbMTgzKNqtXG2gxWe59YeeFpnHi8S15REh2UHvCCrXU2fr6Mxki+qjlY3SIAqtt02zo1I9Aof4aPGETVRzdbXa5j2lW1xcDnRtZN/eRaWUlSLOw1R42HriwE6RnqY0gH5gERBmy4JpHVO1AnlYjSVb7YKqaAPBU9so2HaZS/1qbSWx3DWc/BBY8CJ3bQpFpSI4fuk9UyJMmOzdn2oIk98BELbGoGGOnkRPLcpFqmI+PucIl7oV/3Bv54eAmuSDBPkVp8+CrVOyUZz8s4Szj1MylUwDs+/xpkMcBnhYPTWNDyAQmXxLmT3H/kMNUxm8BOi/N/6vLzvv0y2AWiGFy1kYzh/6AEwNVBqjJB4k3tKhAp05llm9TpYKPB56m/6RoCZDevNYE81Ev/Uj2qN+bLWGOigqcHNYxnPgDJTgQfLWd5f+NYOSz/qwKdA6kd6xugExfLwyDNSzLvQxFyMYkZUDnm8sEMKUL7YTG2UKjVKPlxNGbD+iKyLIPB75tm7uh16B39o1t+phj5627NSYcDrauxhQZ484RIfgb8LNFznJ71bCWB7HQC/HqC+cUO6ayXpWQlBO1QoLoXaRAc2FLQdxB1+q/z1ctjEDWKgXjS4Yk9gbLz2LlHihMJRpPbdGP2h0gbsw0wgu4nw+kjz3jRPfYCivpgc5eSdzwjsaYhUPQNDZTa3Ue+uo2zH8nYrMhzZcwVSB56lxrQGBnyhlfFvKBbkevLL410MTsdBUKglF3qsguREhEZAsYcbhNqAZN8MhERZTxKsfjPHCUDeE27HoES7AmnOJDncuPBCfCBRKSafREBbHRNnkEvqz0TGhqjkWZg9jqfdOMSmo0xeOfwn/IgfQuKqS7oiVvYCYuZqh+nYab0YRTRzenHQ3DIgVZMLLOAwXevTmNjIiSJnpJnaGoCckteonnNR6/2ato46xdQ13HjvtrsdvHkAFJ3IcIIdWCBTNW9vATM0Nq11m6JtyR18xpqC+Ef34BHpHvQWVYDk/PJgNu9KenRhaByLBnCr7xc+uBEAi8KSlySDvs2sIHLAWeMpe1FZ2vpvwDHGcB3I9i2HOglPoGjz1vV/AuAzDSIhrDi6WhEHNlth7yu4NuzMs7dWWhMYwGMgmsugsNeUCmSEQdoIBFj1l/y0=
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