5cGYEnGasD5kpXJ/xPl621TSaQir2KW2712uHbuc8oyCgvSqPevEiELobeGOYjDhOjViXngEaRRY0XfBnSKnwZNkMHfdPwzaazn/XPCv+Z0L9fqt14YxhcdaQyT1ywS/J0U05Pq30Q+wkOyiIwuDiJ2ziY9li79GhcSfn9DnLuYCxb3IBcLNmsbxVqjb5uRcLuLbcOrmpp/2WaJOXvm9R2G53fKTg5ysdahyFz0KDQ1dF42eOV/9rSTYP4ui5p6BlJUd/xwlibWaKbR7sd/k4fMH0Dn+68jumjqw41yfC0CWTelQ0WdxYDbe5mRcBmFzyEJySehFb7T5kAhRl0Ar0EPFQ4tXIB7vm7m6qQeAcovkjCkW70X6ehVH5i7r9vS4hx6Fg2nCbZV4wcntfvegvd35TXRv9sbHNA0oLftL0Gi5aWbl0fCJMuWcWrNacTF9oN9qfH9yC7M8as0wig+lzSZ6vf2ZvYmGju2Vw6Z1aF9RA15QsrmBm9V2J2XJgqtY6HP9Eo9AE/v7PNFP4kEElVatkNNQLN+ItiOY3OD4XwOeZRQtzXgiydcl51tYKt0FW+6Qo1KBwzLX9lpaX4AQzHRMCpgB0B2ncth49cEZLW5syxfaIR/C8tZLV3KUD/k1ULvvx1SY8UWKLtu8Zs4cgndaT2qTPRSqFKxFlYc8gF4ZOityqDTr2Urg9mucgVu8kLJEZNkuGfnvdeYx31jEVBZc0aHI8Kj+4LabJSO58bZ/Grnn4exip9vyaYa7akqsBKtWgSaANXa65Q4qnPBO6JFlNZNqpN/l5uCrO0fWEjG+13IAi7yv4sMW3nb3EEe5MPaqyjj9jz1aE0bYjx2EwfCr98ety0N89taA2vVFTZN0UMIg9rLlsuKXwVg4YEJzm8fZZd9MNtyCErplivQa3dW4zVnlvlRjo8JJ2vgn5nCeK6Uqw7rAWL5S3759GnQEpdx69FOpAUlDn5j+/U+I/HruyWouJokmMoS9Ic5x0y8aUPBGkNTg2wwJMtGEB3NYM5G5KTCeBh3tFqFJ5SlqVxtuJaQYCM8OJXMukfGeVl3nOFrTeL9tU8fYMVINwPfvyUUKNvjOFiDFcbVpyeRWF8qTPvEefkitX9shPYpP2JaJGOFS/NC+qKDRCgpdbi1dRkIdkXaPILRUMkz7ejLhKDjMnDnFRH70vaTHu9VUREHRwAjWHbvGSkpRQPp/aHie2t/dfNMTfuzFjvkmaEopSI0j+S24ry745favIg5Z+RTp0Pv28ZDJWL7jPn4UAyMZSc4eJL9w5DCyNwXbMKa7sdP8Lxm2bT+vaG24w6LFM8xET3yFG0mGU4AA4OdYiz+VjDMGaQ+YDI6ENqVahSWK4lrx0NWLZOcvuu9H8hQ=
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