4sCLJ6QamLKfV+U6+agsai2at2GfqK0P+6HLqNBpoXp/5UlS9rDl1TpvqFMQzb39DZ9HKRE3l3kJ9k7iTWxBRP4ed78sleRzY3zFvIen0I6AMntuVsgafIfP35Upakk0+hirHlZqDcTUVMf5cR+ldm8/GJUoDMUQtwyLbA5W1hqm/B1VfwosiYVK5tJqMEGfDLN2QToEBAuKqdMyASVpaUfDbNcMD3oO+uZtBBm+GJjXsg64eNb9sGJZ3aT/wol/PxEZcF4ned/aGcAuBdJmPuC/dQouw/8EVoFmwrziMk5v6JdrL1L/8KaIdODRaNwR94nfU7DGulo9pgEFTqhjrM7w2Xb6Zy2+N4pGnS8+9esK/51abzEqVBNLoTpvpEBOQmXsgNRTXKDpjBgEoHvWCqvNfoNdM64pOnc0NlPqjd3mVPnXbMcXESMj/lERtgij1SG6ZyrK88jKi2zXFzg3ZcHAspaYhMWgXeQgQTupLwEe5uPFQC8jqCimIFExJT12l64zzFWZCG82iJ6udt4LdJjvkKn/Ty3TA1jraAooPDpXvRz0G0bbJMRkBtY2cDy0AmAfn6H4KfKAVzh9JpwcXkwPlSENvPCLwlnvcHhhCsVbAyrTplpqBi227HeJFz+Bf0byxz7+ICu1+JUg6ZqHjqVQPTKyZVQUBDH3yZLKpGuaO6Lz7sfm4lkxgKWxl4y73oEZ673N8EHILwFKNedJ0SmgY74jA+m9JC5LuUQ2ziJIvzCPxsOBys4TJd1ma1H/H8Qx2dO/4wxtmsbBQmUf+90qaTMzefld9yzPWLjh/TYy8FCZcmks2g+JtwyOfnXjlr6RVM+8jwE7e8naQpFYJaP85MN22qxh2BCBVUXULoQStKGLASsMMSW7Tv9C203V+Fr7oZ9BozoGa8gSYRk3IFXAWZOiwEpRYU/lyfj3wPfHCiblsJOBRs9abR0qF12g9yWhtCVd9HZAn0cfWD4dDVKlo8ofYrTqz6WYvCy/+L1yEJ/VLi9lijjEiKFK4S/9HGS6lgtr0mNQk+pmtuZIyq4sQOjml9ew1/r1m9eQSUYGEHOXkXnSx2knAUetlTpCNGd5lAnmA8zorvAfYjPbxw72gd2xmoGsMCB5YICIvEo+7Z7OjE1f632sBWgzS2oAEDQgKVp1GwCoUUK4WDjLz/TGhYkHlFpp8wwxqgay9wx8ayCj2WgUv1h2TpNovEY4WJhqSH1wt7j1xH3kGpJNE1YjK6kIk67OELHxsg/S5QDDwDIicaoNbbYzY5oCj+dgZGD5ewadKLgLPEyDAHOkmMIoI7aTjCJM89fxWUcMpQZd/ABs1qsdJuGEo8cHcfIOHA07Rc2n3fa1Z0pMi9sHC8uekpjeCaedYP4VatU=
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