exG6vJFhZg9JgUjgwruMwkMtU2F/WdepS1Tf4+GWpTapsjJK4rvs/zJjfu1L4rFfNCKT3INxLI+fi7agFYeotaDyeVOKsosuhOun9ZiEiI7ez8RUxD9dCj1Zh3rDo7Fa/SCT07YW88JxqEbVWDE8YM4Pn2AUZY67q/2SVwsjfvwLcpqyZicUAtjcdbhujUbHyjZl5m+xE1lUAWl7gnySui9Z2m+uqiaGPnB6Hnk1ywDvPXuxbuWxLWanA8+mKJOaujYBA5Jrcfq1PFwD+Xk4pGtNc7Mwh/19X5nCazCAlX5DgqATaPuEJJaK5ofMF7zDtdcK1ATi0n7wUpPGVD0vH0zIjhAPZRL523J7Y39b3yE+3ZJynTzvKgoshdTp7xFJ5Fkj44KkTw3pkaZRzzQ2aVO0POXyVvbqxLXjFdmlgNSKTf7uEY9Y2W4TsSWYsP6/2WInK4rQGDsGMMUa53KmNcmzV6/d32xMSpbwf+HSZFqQb+z12NYhBV+0enx+yGLFkVflMvqEO9QImCS+pUECIjzrn2fuyjOoJAhHGgHSH1or5pEYOQHpuw5zjiT5J3mXyuDIu4r8szKQ9yVKRjeSeeIsl9v0i22/3kj9N/rOeppbBnZFnogP4p+FK20g0J/Ehar8lRXS0lM5zG0f5mr/+UfOYkNWdBHEfuwe6dmN/J7MFffHhsnfEOq5LOvAgOLKC/Gqx+bfujv3AtQsI9XkEnVrH3AcUZbh7Zif07wMWc9iKjDN3QMcpOTEQ9uHUvqkRupEb08Dvqe/2a+OSFQtFFGrd7KQc1mdBfoVaGv7cnX364ZUnUhMMdaXj5vy3et20tqDNsRZ72cvLI+5eaL85o2WlOhOd8EaRFIH5KUrGB7ndzLZa0hy5w4uC9WDid60xNOjT2umtCHpn4asO5dOfd/6oorvHiHfAXHuQzTkx+2e2EiU0HrwMz8IqJcQx3iiW/8+pdbCxMILyNyIc0elOJEF3+5xm4DvDL9jGve1s6Rtu7yizlFZc8OPUFRVu4XNnoOHVVvZKMhbrPtYTRzagvp8KBm6eOBcd79zuBfa03z3HPA0QtR0PELKg9kNGX8htM6i28KRaB73HlhtRPusTAtBCOrdD8v/J/J+HhgNc3JgnXVnnlG7SBg0M4tL574WIRzzZmul+rpS6xmiuObD4sDd92qYaYolVZ2Prep8m2c8vt/aRphX5j2OY4E17zVoYy8ktjX5yVai7NVfl84xbqXK3LnRlKifiB2vNe9xMQGA6+DbEIFKtQg+UWnpaekK2jHUcPHo8oXUmdKaFWevP+PSTGHNCusGBhCEQpQhN2aOwMN/QdfmBWezhtshIoQNOfQVTCCexFo/KrShwasp5UVhey4KN+j8yswsN8M=
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