JCOE4DNW+YDX1NRzUm9XdQjmB/YZ3Y7Uq004TQWa1HCk4XWuQ7M86b78b7p2/xQEplfMRBBbViS1TFTO8VXoklyCA3QrkSeDhR/dz+a6a3Qz2l2+p3EFfHX2wy+WfvqtXPdfI6LXKe1ANwjV8xQostmM3Sw5Y7BCfcXgN6jBqOqZOsC3UP7aZrrqOIxJm4bMSD8cgWaXGgggR1JPLEgfWg1qjYa1NHILLQp7C/oBF3C0IVirJ1M0r8acu3/+qeQHAXtldTEVWpeT9uZEbDeJvm3EqAvUBb93YnBhcxSyfDAll2jIUzhGnvf/DTlEQ/tafuhm593J+Zzu8rFYRBcIiMTZc23+KdL0Kso6pWfysmWKf+m0TEtDntkXiXCV6ZTyC65yerBUlS542B4SAnPPT8bp7kuSMqP02S/++nJ4bPMQvF+u4Xe3C/g83AodDvfnmmI04JIHVoIBQjw8xpcfPZbSO+vl+JQLdRqw7aNL8sMAyuT8gbyLlfqx24FnoJnfNB2XlwNrrxUuK1oTXVaAAyxD3LauukYcNTYa6KQRi0XsK9x4Lw3bRwNM0AS9h46KnRHslUPPPW0X0g0GABR/RAs/jK14ju9wBrC/TKbyF2kGBYlyirx4zMR0rhkICJwmFw9KdcS7Zo8vBGTZjhAOyJ41IaSDrHAXRuhrlYcKAT1jrB3SK8ve/0jwZzLoJmTdGwPwB4Lwp2EBQvmc+iZyeeR7hFYJelSteGOgiczrQRithjLWkBJ/SvM5GCJ8DAhN4+/3YSE9tU+KTWjST2Rs9niCkWtEdnUY8lQ+HAAYrqP0b3bx4LGx+qx/etx0YtwGL8FH1GcoX1NgLTfB7Ix51lKvhDEXAe9Uroyxx/i4QM/cvIuWh3G00FAQ7Ioiy3fTXbi90AUhyEKO1wso4HnxXB0pJhxk48/xUM2e1pWJDM7gmrGzEmvAEMnDlRia7Pzv5hxrfm7T0Aj6RzwIKiElhgb7iGQdYcLyQ9VGA6Wuuq2VO1qUBfA/dmOTDlNvFbwfKB5MWflEGudi1vdykeEdrI5jmTbcG52Yw4VJXhJIiZHou4PLYpAqfs5Xa1c0aM8ZqUjLD1YqP6alhMu/r6MDkZa9Zk6BLiWt3WHNoqwt6dJN6q5VnZkNvA9MmM4nRcIjSzbIse/T7akdmcsbd+gms8CMLunnpHo1xePOpgHkD30u0PVF6SuHrRPXic7Ekr4DaqFrqmixug/5siKZG4znyGYLzaN2zJ9Dc0DFS+8jnrn7L4rX3UstsZb6CyoVvinAQTuOqdqoSWlu9NrVNSZSYQ4mma8TfW4DKXMLwmXR0Ac9VyyDZnZD3e8ET8UtgqdugzbZiN4XMgC9QkVn2roaqCYXOH1IH9ikQL6macI=
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