OFqHFYAzbmRoXwrD2ehX67sUH0cY8YQ5iVX2tMpqoElLO8nScDm3JxuUfaxg4lfv+ohk3bTTUPNUZU0X86dhEgiQXGhrXsEpQd35+ohNUK/RsthEr1NKVlBuYvLblTSueMlsyFiQoip8SLhgUDx/1MBjMkcXQRn+etwP/OboYyEVdYHhTiFEXBrVOf8Rkfai4PpZXwmjHstD3ylcZDRJ4neMWNR89AQeO7m4T1zCMNEDwMhla7KcSfkd0U5WXjruAb6ZqaxsB1C6FfnCv3T1x/o1SxxRCKi0ROVBwS1AmIBZqNO42uc9aufu6SW0Y7VFq3uh1kVVx97Qt40iEiAbY+wxyaTjOs23Tgvh8vqD6WAmjLwXqu8ldgFAPZMenasERyWgM+gZ0R3VHcxNflaDQdnjBDZT89v8SxHn2QQrsdUV3WIPNAthCFjLL6umfzGhvzaqdWzsnheotYG5+LguSRqzVspH2BBNyQScJplEglJyexilG9qz6o1uj8UXAcO+QCHMbktCKcrM4dJFTb3tns9t0XloVvdEiYazUr/ISpiAkUNabiOeNqzw2X8rb5p1hSLASOFxG1hGsUfbzou/FPXeOpDKwB8OTH51jAR93HggPMbiSPnR9pq3omH5alVPyi6vWMb48VG7FbnX6fmqSTkA+PEbXYua4Draw1aQnNfZlbQhK/LvdmByQ7p+3x9yW1xUUAV8YsFxiop9zsNMpSh++bP2LqzWDt2a+4DoRLaPtWrtHKATZdfuTGNMYw4uMy/PuKKnmV1/2KR0SG9IUCUdKinRZr/JZPaY72LcXqZD868GB8OZU4vW57kLxQiieAZsUYlH88cWjDOE/tPb/+9tLYV0PM6TpXwCvkYOphN8c7sBGge84TQ1cFF1I+/0DnoB3yrOystP5hlwMR8zCs83Ktt395BI7hZEiejKuQGF279CwjC/5D8eLDvKhVu6dpEZENevYx/Fn4XbAzBgxAx9O50iLp8lzxaPCrtNPUCBuMhW9eDECe4ymmsKZLO1W8D13Zge5eXgv2Q9vRa1/EzdUNHe9VjogCujspLNfwKQ0ujUEEZi/JD3cvJwO7MrOd1r9h8f98PYry7CBzLkwM2iZN/iZqspuOfGOkokpe9TEMCIBMkQAIfdHbP+vulnVJIGEiL9sS3qKS7JEJj1e1R7QYM6VMPQAbo0N3Ju7lDSnc7odZ/axl/wPe6qIbMFQ9mAXsUvQ5/hSgEREpy1gv6MSbpb3LrrqVFUOmaxjp1EI/t0anBOE5lbT1wRdU93stnM4Pe2+em3FZsauoPhZ/2J27T81En4+JLhmXA+7E0NXA64XiegeBl6i78T23iFLXdP25qy5ATdXoSyCLptYwhzC/92p2PYZTVFVAk=
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