Ea+YYV4K9u9AGTjH64UFbrfDtEdc3xUis/FfA7nm6hicuvfA9VDbgs3X5W2iYcE1JaPxlny+I2h4zbUbXfyGpouoc5BPAaQhTxVQqpu9ve4VUlQ8muwpJbdOeYtxOXiww9VEazXN8TDxFCqdVd53jqLLpippIBhgIFsbDtaBQsrsLdhdIA5Mv6gCdiLppxfiHscVpDJpMg7KhgtU0jc8QNdtdPPxArHv4wJPXULvEgzNB7anh3lhMlnBu2tcDsX+Ijts8AoAkpnPAIO9fEB7n45zu/Rin/d4kDBCwKx9178CfjvXkKNeyGJGJsDyyEILGMZxTaF6Tj4t+92pLmW6Uhkl1S8dslx0D72epdsKELVexplT4IOUkSyNdNKKC7fisH84T6ToFBl0aEBchLt1NAvW9XaNNq/9YJiWQSovt3mbRYm+j3pzplozBaUYicM/aoubqBOeyG8N0RKiHGEYnf48CPEFfuIudAQerGg1oFAXuxsXna2kGvCb93WQQRbFV8XsARyO3hcdQj2IyhvizOTIqOlPnxuT46zFBBR/YkKt/Cpxr5EJYrOwiZP6ZVgK67gM8/gtL5CPoqjiEbW5ojrRQnxhPqP0ZTQuz5YJfEmki0l60JpLBmNFPLkkEERtngmZ7/YRyHV7cv0B68cQwPeX4cLaRlFRBOH9J/LCuhpwsZyHPnQhWloX9V3+sfYyaVmqdq1JGO8V7DuyP9mp3xgHuCNsi4mrHkoVNN1r/fWIBaOyoAQZG1oHflyKa9QierPM0uHoWuOlhElHU7yy1nLDSWh8aOxRD6e5Brx7e4kAY4EPKIwdms/16qNosjtYLrJkJanb7159oKd1FL/GPNO00a9vtNOBDGPMLNUqMfPOFIpK5eDyeLHBnlWbXn3bdt2z2jrybokf8g8cir61AxdXmBt5sb9U3b1q5N7/izxTFhlScilQHY9duURfof1xXnhPvvCzlkoqdU3DTt0xCg3EzwF4ILBsahiYB+pj4zCjfoBLs6EF58bQnQ5OM7RQ6bWjm2kYc9Upoo3Y+n3r9IjDV+eMR/cyjk5CD+ClfTXP1QJaEiRKuuO/hW1G1dYLIQyaSzJQ+nPYS1E08yTCQwASU5opnprXqTRdr938+P6T02u0WojXhEkmSlSXtbKfgZSAXTf8pwMa133p3KtQFYwD7b20/M1t5YHG9Ynq1u3GO6i1V+igoUTJb48pAHKlq+KXTdblW1YIrmPwhAn4IGOV6Tc20XVV01liFfCf2VHQUs+ta7vzDZpPoGoeK8nOGLjTUWRuTk0dhafXU+L0mOzZ4EQEk+nM+Vs8Ojaqb70KYAxL4Nuf5/PY8gxGzcs2y2zIzNraOB6mrVeqEtP94XnPfbTTOouDHGUX7Kk=
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