PuERPWjAxqXurTH14nyAuTXqVRZ9YnoDmJrfJ+/4ShvbOyzhIe/qo9/mP/4Hhf0bXfbZnHTpRn4WHiYq9W66iAZqRzoQP2VLuetlLfKONGTBD0lu1zui0vyAc/Ql+mfDxBr60QUP44ILzUMtAalfyjF+SSZaafTMuicibXYp6CMq4IiJlvslLKoRGnQX9eSLAZtjdTfs5M9LjJLlNHrY9k6vaSJ/OJXFt0yWM16xq6gFMaanVgXH7NwcCwjX6GGGJVS9jTlV8I3S8tHJq55woNLOiBEZzaOq6cSLLFPcCeKzte8rRI4TrDbHuZwt9iSpQhBCGScNC5jY0oZX7BzdvhE52UP4JhPylRbASlVAoJRdzulRfv2WTwJX3nREcJDUdQvLCkufEgCDn8wvuvOOQxNoQ/1krmmxQUZQkWEJQtXnv3mP8TNPMMYedSyFVMFTLVYzt1/jyXPqpqZsfNyrZwbbqo2P6Kr8O6J9dS+KT1wGD4AqrwHSR68xJBKodM8ypMy0IhrtJqko+e67T7SeudkmTCNXV5l33GwbYNxz6UZfn9tZokY4ln2cYHAgS6dmwGx/4W3VNh/INNPzA41E7IkFxOlY7fUnhC+RygYefEyrtou+6xStn2Stl0rT50DBCIiLS6MY+/FEs+BYqDWOPHwruvazpuz1dSzn9e5OHX8YSQOOjF21LCmEu40nCTVg7MfbIB2rbXQb6Rhxg0Wr67EYaXJ6c/vPzVdJ41VsTdsZIQ4eL/AaU4o3eAtQ6bcsqeqVdz5cF3ZynZkTsH3r8LmtZpcJW4KcY/lfT6WoQdDkwXD7gtfN3+bE+JyrOoCpqQQbwh9sh/j9Wrb87npxO3/SdG3HqXjEeBEXIvoxqwOsVq4Cn5G1uf5Jz4GVBnaqX4V50KWPqYx523g07Mqfvt/TCgMWJUEJkz+A7jAnZzYrmwSkAUJVkHdguQRjxxhsSwlQ10ERpWH5CqQe3KCWeqbmzyjuYxa0Us4nNCZtwDaI+H2Try3JPjKOUysBOjuEnPFCZE8E55dBAUL4XPNeFQx6h3+3wMz3MhvE0Ws1Fj7w6bUAB/BKKREU2qz6eE1J+f5lLQbfrxkIxRT958m0zIPF63Wbq8tqrrQnffeoDP/pm2NV04PruK+Xd05L2VNf/t2bgg1iXb1Fx6nMdGc33AzGgn2+wZA/Fbur5CK+DJ8J3xkaP/JH4+lPm1gvKtBZyWqH++9lsYtIrXnzf37Y8DXmenpKRjwR2Vh7/hM0mNNP/VvVQws3GmeR1D4QQ7RpXgEHN26BdK6Z/O7W+Nxk14EA1HPxpv9pxg0ef3gFOWGLCADTi7uXdEG3gQh/smPFacIf+TofPlpbVNFs73/QKK8xoGH1Cit/S9drhU4=
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