HN1ea/8w6YJV7zmM6kkdxCXQl665v8CByAwkKzggWFfN1sbQS6HdM7WVpK2P59JtXscMzhhczSeOonZzsDGLoHptwnkqhNVfWC0P7BvtT3zcv8weY8rSFgZ//Jy3rH2k4NTEACfd5YyRICIfgzBcgXOL9mOPvVX94Es0bNyzJDhDQVhEGccINkumu54pWJGILxwglUa/s2RlhTY9Pg7rAGTN/NXMSaeGoFo/zlebZiXDBKVNK0quiHf0XvB0lJyNjhIuJBL6X2pl1LCuv+gqKrPPY8HeVYO71dtjSEtFwK/VfEsQLDRLgRjbxTlyJq76EocW8YMmV8Sk39hwHyDtKbgbrltpmVKjcnI5ccKF+fv5JEDHxBYH8hXEn7dnfqyQVfihNosaVXsopJkUkQsCj3aKEduOhNE1j+gDtdb7NSofV5ZoM5k4z4i75Qf1Guq7GTMgjyPR7zcH9EGEwYBaolUWPGPv6f9FxnGvLJeFN0X6uhlA/+kZI0nyMN+zZ+UcVP7pJsqsCI+ecI4tT/trYrvUburTBdweyj6b0apxQ/BVubT1C60IgmeV8JXqGexzg3VjNw90e4nvQysIaaGvkUSFfEtaalg4Qs0ko8jZtlpkCdmF4wiysBXPDl5smndK9dUh/Kg6OLNNPK/uPRk80DFyd7YGP1erKPbzMiCbjMP6Ahxfl4bOGHJHrS9aGk/TzYvDpMcHuJ9RI+UzuF6C6ouptcE1EQTFTKEiK7u6DNGkZUaxn0vgipDwSAf/+R53BOM44fq7sNokAEv4JmH9TtMqEXe8qMboUjQw+mvmgfd1G7W+UeVVstYWAXZ/9gSDjZ3apO6rOqGXXIZJ3ruaoa92jGh8tswWw+6DwVh8xuUPMOm9ODc9zwHavihqJf2qtTrirVOfEqVeIWfQJd5D9P9j5jgowDOoMjUWsnPxB21AEhkvVJ/1LANPXBgtyj1yIJLFo5LMj2q16rHE/vaubHWCXaO/PL3l4zasGhbDThtcoax62Nv3nPohw2r1C+HDtlMm3IxIYc7HQ3LhidK0qFO1xcMj7Se8a5smqxUrL36z8RDGous2or4H7Y33Q9PpCR89SlpHHEy1lTPYPIuEAD6uqOxJBHkuAhH7eE0AKwTFmLDNMM0pxR0vEsgMM4XcyQCK++AvH2Q5ghXPrXn8H/LO3hBpV/5vXNw/4SZG6WQteHoNzLM3Dhg3jyiryM0Io2M5/qnX/2D7fCsTJykZX30MIWNcQwAbXW3zMiAA+wlZpwHN84Yr0jG7N9zZxHtJnIDZ+UDqZMeg+gwn8mmXIbdU8FkHqDymIyrOQ18KKbCtK04kFZv7LdJDtYtvyZP7kteDlsGhOKvKnH/B+x6/KBk7Fp+qFsIRYB5RwZM=
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