aI72X4iwkqmzx2UOKCbeGRB3ezcz8qkr/M42CMuey8Tjur97rl8tK7sJ19Bk1PpP6CW253lFDEinYwMpl8d9mwWlLdSTZBCiGmFg0kD0wy0D0hp4mk094YiECvooLuksjaNwjlYzeMTGO+cxCzlu1m5ujILu62MIS6iTgGlYPyJnQOSplMFvocOuCRIAHxkTuY6d7Hyq5zVQzCTv4Kzf6pj65+kkmvc4cmtSgw0fJcr/gvyibwtuKPLlKw68014p9xSuHovvefCkPcxC8Z6dXbF3WKDk+W8v/QRNnyqMgnuuKFz4pEMG1K7D7QFPYsCShPJp9QBrwCP+EA6OsVvoTDugR+CXHhWfVp9uQC3fRB8RUqcqIyXlmxrga2IzdMEz/fz52gkmH4k9ntZmwaH9w0hedFtB4l1IVPq0bx6DRnl2e16O+pJbnYmRv3PZ3h9dAfyBbHivQTkSIixmvyKImlYO+gbEiB0Sk5bWKtlobpXcYVdJpvFGuTygq1QDrIqSVpKRc4Nfy0ZiBsXoNF1Yw41MiONyFqtWzGl+VClBD6DLXlX8c33nGgFmR5pNl9mM//yFWdA/oyERPyEOHOr2kicB0KmME/G3+lw/XYxgcq7IJnXfz7baVoKNENT9xU4p+i+KCdlo3pDy+Q2vPl7ve5iT5lFEeMAOffIR5w+n5cMWPIkAMXdaqnEwSCOjMj+oKytbfXLurEDqqVuDkyb59MIi2TWIU5sOpO6PHR5Kg0nOw/zbuj4tf7dUZqdXAHIoc0guQQCr1uJ2/YgHhZn+3T2VVBqJQ+zBvldn1ADSAI5NQPjR8T3EIo+gRfnBeiqGkf0NVCghEfZlXxOW4nzWMk3oEjmJpuMby60RFMEvaNdXrEFks6TqsZAQeDe/tPS+pivD8RU7zR5ay+XgzIttULLRy5SIVeIk3Kdcj36XlYaVABsfBViytrZqXgTFmcivFJp0/KwSngSVvjTPR3VhTl+f6jjRwmY3o5NgPi6VRtiF3OTOd/O+65cA10yuthrYufFlkaN3wNs1xddekO30iRoKD42/9s8kcU0fns+WAiMsYWtSMDTgoQAV1sEuOEQbWjrbo3GrTDCHSRCYwbui8VKg58/VS5Jp9USyTNhYFKxzwem6ZoAyr0bzBDCz54jaGuos0PryqKkUIsXh6UtqVLC38IFnfNu4ymZHwWrysJmlYKKd3WHOTYy6xPzRY2APoSurVShlHYep25vyZaT+onOCflUXzJV7+kLQqPna05CA+0fjghMJesJiBKXWE5CcwAjxr4Tnxt7+CFFo2/KZU0xW8rxZjbiZee+3GDIQ41HYy5kjjnTIeZqefenkmWirPim8KR+fx9pFC38wUKTUMBD5l3CefSqwbsK7vuo=
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