VldVGv4rBH20bzA640Be+ziEJNW4l/AHUCsUXIo6ewSiNUyycgRFrqDnOue4miS9W08jYX/0JP2cCnuYAGNu5mON02fRG+wp6UFHrsP3RY53+smHM/Ndn4PvwjrJSPiHIcrZKwB2FWzqh08OedaNh84b8nPzbA3zL12c7J/IAzoX0IgmayxF2+fuh/idIPPaAgbyzB6OWuxFmOMOTNDqjsosMVEGGzeV+nSSYyQmPIw2xuhVxgyDqE482qq4npHzRN8p1YDWUmFH+H+BqNlylkGor332A+PIt1HRYR/eiOp+brdhHug9B0yces9URT2YG98WscqfTt06cXCJO+KAjCLo/cBti006iWeajKOt3tFF7lj4EyiKJR4NYbR3oZwyLomQxB0itGXHdP9VcWM/GLcIe7V1OwYBXG1FHEs1KX4LbPlJeBdETcne4Cg5NJQyODIGL53KEctOxEy5n1GN6ZToOSla08wJgkgTLK6QV2WvOVqC/uwFXETj/bxnt5VU+eta0CQtxTDy7fVNXxUDPCdhPzr94+NVHtNxJww4nN2gGniiey9MUp7Lx35btBi3ug+ZYwpgXJjGPAKq93Z+FMOuFQRJ9+nnXJB1Q6xV8PLy3aLEb2Bsu+5UZvGhCw6H41jXguZRS5EqXgOgL+I27lCw6BfH6WWjjX/zVtNBD44woU27BNoK+aFX6nhFQTHAAME6H83EBmSp2/lA1nS8oxdP4SFrVs2dUg2LiJItokn/9s/gO0WcgqgmIqbAPO6L38uBBmb1YheibX4H2V6R+Zbpi1NqFMhZOuTxP32NtZ+XIUwl6kSOvBz5RQo9hVZZJn7KJcxOODIq9E6sBmjZTxoVFcaB8ho73g/EUxc/r2gLA/u+ZLr/+xaiD9uEOAr5Pl2ipjZ8fdLs2EFoXD0HaL3R1iNfh79aK3MlH/vNcOjbDUQvfdmg4h8YzBG5Urqbe8QdFkCDovK0yT4Ewee1YVygARgppzC9V0LSmTWmSdLR/3kbHobbpuNYKPbhchCNGv4eiJtfU6UK0y2TE+nyW0JixT8gHPy2lZonDlt7OZJhewbvJyBEwoETVLRPQ+J0VvZ89WfDrYLz4bUDjYjDVVTFeDBKXvk5erSjPwGQUNh9oUXSlHymjedGjK9jjnR+NWKaEwIf7DEK34c7k+EEQdF092M3THQZnBUf2ymxqOREHAgfUFFBfFlWmwurRUPVRS2QAUzG/r/Z4tdSiQLszrHTPHLEoSmLzIrGKpiatz3G+MLxnKRtkXR6W2xVxvRVSijvXKMCkBrPm68UX6JaLp9xxX5Z2CA7tIzVNBqsmOZCtQrEmvF99BjbNMO23e7iPApVESAFTyPicfzYyrVQzagVwuDulYKjbwTWVs4=
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