2tB7A0cE9w/J+c+z7UBuLpGVVgKceypbc7aSLbb7ofikOqpuSMvcNylbo4Sb9uvz9jR7yyzOwbDHQY/cqlmZMRUsFouH52RXrCtP6iKDkZBLz9j9Gi+GgTn8EG/Uc5ac2BrdRvWoHtSgxNNZQVXBUmO/XP/jnltlc8zmQ2sj8519bEjm8x3D9+J+f6SSnzXa8E/lvORn68kuXfeSIVwYjA4Y/h//nXoL99GRA30xMn0tkmMM7jd+Mo0b3AsUV/yRUTr9v808dxJEM9BVWspLlSjxtAlLd7Ddqm4H/wKrdn4BqTdoxWkRgE4e653GmG38Zh9cw1e8tLjL01NRLlZlksRiuKG80ioWu+gEVWvRvCToHFTfMVX3tXoj6CoWicKqq4yk56EOBARxtd8FviTZGUQHim9/HA5zbXw+PCWtUvxTuWSNgXcVI5JKMvcZuGsT3eTghw2iAmzAFtnPZRKi9cwiG1vg5WXh1bctzkMMXe06xjFYnE0ezcPKNwqbHNmueiVSfgtIB1ouzOuMNMmVkOcb34WIqA/4kHcFSvpTTeqo9d0HVRnxFlWyoyS9ZkWZiQFGp6St83k+oC2slWGqSRm2sMak8ZRJBGv3UqqtmwlRtMP2ju7ZxWpnPd5XltITpZ0uU3V+67J1yYwD9If0H/kOUjfdFiweN84FJkW/eMaFHpfR/EVvbyxgv7onn/rDWNOXz2OS///RisAbBbI9K05AZkkFcydLCevQIIVj940tmmS2RPMk8qKjpB1k+AmM9n4Jzt9Dk/7SMGSGEaHh0S0sxGljBhvBPKNMRSgM9p6dzgpSmdEf7QxyEhBNZyi8WJfpYewv1gfU/KLw03sxE7vnqRMmErYF60avTQiyEAJeQbgtUBQLOop9I9yKRbABas3Qz3dH2dc6ulJT+ezMBA392kXclZHdY6BKE1iWGJs1Ivc9lfrS8P+MnwxZOgkET3HLiKJpfe7kR55xgoitgCvYWI8bcilRfio1B2ZjM9JHbpPs8iLJrnlBAlLzZgW8Tt7NPSKkOryuufz6bwVfuLpS0l9SUgLK//4bLfsLsJVnW6nB/RYeH9kkhgRw1sFHvtkYy9UH0JhP1ahcHh7cI/XLFYlprLFvV3FP5/fO3PqtjhL4bI8Ar56B336Yxcm2AiXFFlCmfN2PPVws2rNHZglt6GeDpUiRk7qgJiNuADjBL3A8p6R0BODdNOclqLharsiX3wNl28mVwVM1ErQ4gRkZnJvlHueC9Yfc3IbzkDcW0XLlkY1HIsRcan4P0CnrfiNRIA4idPjYSXS6U/B8N8dJHiZ2JhwLX8YWPNfLXDgpGjZxPrIawYER3sMclUWoJ14/4bN+QAOVhn0mjh1ZNXOAbaQ8nWVto5iCYls=
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