hP2aHwPzEifY4DaODer371LxRMI4OGCiK8MXZWyhzfK2+OFKZ7zt38sDBjaFZb2ob0sq2d4tVpkqz81suRviuO42PrYGM+y4CQyzwVpzJOxPrC+/D3+aA9hBytZDsZ3Exk0Ad++H+mhqH1ptRUoVdRXyJ0gPp1zG29TOGUxv+ZRKv5Wxd7Kl6GfEP8O8gRXO/oQHhKc90SXg6PMcqqST+NrPloT00Y8MEiIu4c/T64N4WTeE1BS/+XL7bl8TASk9SdYiJpJsTrV/LOmkIbsnHINgKsCdu46Rv5ZOCqe0bu07c1m9cNjYSQ+FCUsCy0V0kVssgxEW11HnvjrVBopw0AUnaBi+0e6DT3cYhXs7f440LHNOlAO66KJbeArHy1LSGRbMkgvCOx6Y4L2UzzR2qFLbv5Uu5fGz9fVX+XwRjkOJd5mBxlJxViV880tkY3nm93DyosWFpyAKJ0btZggx/pSyluOPM0XYqR4p6tFbBvDFS6nJTApCfBxX+wDiElGm5qwyAFUmFnI7hNMQo9UAsg5TsvWQM5DfMaVCH1Kzcx14InQ+Pew/yUI6p/YKjhqGGRn2nvsFEJeYK1Pu0VbK9fSqGx82qhvc7aZ/Tw6e5x+UkH3qs3e34Thto2WRosiqluMqmof8fnmi1/H3kmvJZuz1Rwo7yj0KIf6Bul2OwMj+pn7S3OS9L7wMXBbR59j6KT18KhUzCk1rmHKRpkI0ViPfceDFQvOOG6rOtXjL8Auw8Qtq4RAT9nO7DEhqVZ9hYTK0C8LthThsYAEnr+M3UJetNECFeva1YssvKG4Ss9cpEStAUwOOurYy7gXPkG4IyEwpMvJrFrhEdCJwVO4scdhWXUlkzBnB8X1uE11cSVevQ4JrCEO1kRqzUTdIdmHHi98Qb3EHBC77iLRRoY+IX/cIzGh2NCddhew+TgGJKlcCJswvYHCFixdWIKWVo2kpOORaA8un39pYh5sq/sP0HSVV7N0VsRNt/Ybx0n2b8D3orpg9o/FIT5iAPxqF0v1ktqr6P9tvEMBRqTwv79GMmBkxdJRcRLEF/AIpaUyLXf5gQD7Avr3HV9mT7hV1qFjDuLTbp9SuvmSTvQGrhVIyj3oPHhfn8B77F36wl+3yJUCn6MDjIgnviLZMqWvK7P/0wd0g+NA4sBQtLrG18KhX1em0XPPejpUQjLNz1vMcHDUOcbm9V+6qMVioPBj6BBj/bWR+QHtIOl/hS81z49SNoxj8ssWp1oUSkbNsbQuxCMoh1yNGv0IkWN3iRvfHmrS0CfNCfSxFs41PWhmfKK/BRKDYuNep4kKeZtWPGZK1dhV+fJQCxSqKREHnzb9MiQ6EwtNOqvhi62FLHWW+QcNr1slorH8EtelIeqr3uiU=
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