4h6YU9oH2HgOLZqKsR4DP1z6yN6PdbC3IuIIEoiVzSG3tslixNfsG9coIpJpUgcT9Y4D5VD9VdJA215UAq6NEjan/RS+oo77c6zEkDl8mu0mRce6y63rIRynk5hRb55hLEsKx6dtm6tczXIrpPnCHedmEIAX5sixP+58OlvoZgrIN5Wk6zbOsRNQxTBObFto+TDdCFD2ktgVadqF63PpnmhY/GOnNEaS8A8+aXbZVU+5hV70HJJbcY90HeOx3rNgBGmxzCj5631Yg9Ab8IqpHGo50QApBfXql/y3eLCkns/5HQJGaSqMzBJ2KukC6XCLwUuAp3lzMVPgH5htAgcn7LfQES548JaW8sZ/ouOW/Jx0UISFCZefswaoJZ+iUAt2wL+zIPoWpqd0BbQCIfFfhWWm0Jd9IhIp/2j1hk6Z3URJvHiWue5/LcDZhbCoVhFdbZYm3DywLCtYpkF2U8noV4Fm75CVRdAQ/zEoBkdISAlCQ9Q0+ZATiTm4Nv2kJZHIUbUp9dHzCLkPs9lbRzH2ygihbBVxU6LeA9KCcfW2wtD7zPssFxIunsYmXaCzEnHKBdxZrbGrbNAy7SfX3NaX1CKxYqTruBIJS12G7jbxqH10x1c1ZbfDmFOdcnswJTxKBKhXYi63160oQrWaLqFv8rfxAVJK0EQiXqgrWpLiBXfZ6oSQ0B8bpWYaFWVxXAKnv/mPW8mBpVd3z66/TZQt18p0ny4b+o8Q7AcJsQWXRseqrWI4f6PrTxU2YhbpTKQD66PtuXqQoaj6DwDHQZHJ4p+IbprnTRHDUhpRwBw7cbmdF7Unz82HkRfM+yMNi9zQ2bbmTB1lzG3uxVzTr9Q6I8KspjQ6+EhM+4wucvcm0fzcfrYTI6HKay3P4HN2fqU/Srduw/JSZdHfFLRounkYEvWnnJfdFxf8Wk3r6E6Fq0YZdhQbHmrMp+0tF7xQ82f2Ic2mK0Dxswo5HCRdVlIVsZfJYAdZ9l2J+hEFraf08wFum+22ZqAO6SOTZLXkgsEoNYyrLRCgdwDja90WMcogm8MpDnW7PSqlB9nqxJ5ciWAGfj06qSZzG32M9cChz3QnIFfYmuBHP3r8NBlEW2CuqQB1G9+KFVcJaoZeA8iyL0V3yLbIH5L/c+8jnYRZ6DGRBI9W0yuqpGkYwSHdn85ZoGd+aF18GXwvUj2sNniAzLf3g/C+UICTo2ox4c/TzfrGQsulcWVvRaLPJDtC5zV5+erEhRYPjHT6eohG/4r//nGJR3kCf/LbARlCt8HZz704D/184NcKcvuDOgWbyxffoZcJ1YBYDe8Cpoc/gl7SlC2X06e87/PNpl8Z9TS9cm7sa5/jC3oMo28YA6zuIDs8AfhPkncPs+GGfqY1uHs=
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