Bizal1AxdFeZm49KrShYb85825d/MIxk6ZRKHm8Vsvs1dr0rpkBtPcG7ciXA0olDRQkasuYX+y27fySiiesBba0QK5hf8dwF13ZAWIWt6K/W6zlzpSiFVflrgStggMQp8ZOzGkS7FhZ8UAEYJ5nh3hgUUJxqMwjETMUPQrxkgQrxhFUlboMjBTvyD9fH4Vz9bEC7VzI+3V+JRbPFtc46vDO7wgQdZFrIlpg792yR4gnpHPxIDv5r1Aq5gvt6yaKUWPY5TIpKH4KrXp00n2Vq16LHzvNGcpis0xFhB6D4YIQfJBLvRMNGA1OQwqSNuJNstDM8akYZMtm7Q75SeiPEbY3u9nYgqMUmSckzLNxFpMd6tHhroJLY4sh5l7cmImYBss+guR2HxH8Sb0W5bEoeVYzYC5Tt9uq2mRETyRaw8t6xL1PzZIl1GxA4rYHlvi+cSvKgDz1rShqm8qIN0/U7EGYZ8fq+UettbHFbkT4QzF8bm90iG4Q67mOrTkkpmVGyP63J5zvuG/wz3umFmSH+KTAC0ewtHAgGzotLNBw0m+mN9qWrytgaDWFhyPs2vJX1Po04ktRhnIyVGphaPfeBvPWSKLccipLBCEuq9bbMhBM0CBr1r8MLhZHB5BGnXacldZYkqWVRYC7EALqqqfkhKBOqfUozS6R4LsM29vCRdolmmaSXs3oQnF6T9ygw44kC0xPJ1PhsqzMmHyOEnsC4dGKjpTS8cHgv+etZNRa0vJeUEB5IJ1yaKhmGQtehMLuqos4c+5tJnqOm2uujuSGFo9MxQjeADIOGpe3tVCEg9UsGBNli0FqNgQr64y+PtRGWOOQusffJu85sPC3sKkUSzP+vZP24VIKkPOSI3FDurq/B254Ad9WJ+ltVguoeEgYx2y9NVOOEiuPVfz8E5KjqmixVmR4xddxV7Kx+nPN8Z/woiv4pb+DGgWGuFsG0nNbVhzpN+Oad5S0tzUhhPeiZNAX3/UyhtXmz2p+eGPl0/9PmVrPQcYAkob8Z7EoHaZUVmdObT2kN9RAQhKFZOWYknWialkpZ268Uj2O5wwCHu75VrQYBSdvrNIbBB4QZEo5XMYRfGVrpJT3YM3YXQDp+sEIUQ9jpsj2XfOLMQSoBSfTiaIEqaf80vtqpJw/GSat1H3EU2IkfyMwIhPMk22dJ9ukijDIQKOPpevaTyovONKJBum8ZHUZiPF8/tw7RN5pVAnvVGixmi3DLv13GM57rm+wk4kZh6SQEfQJp4RNwIL6BqJMIKlpDZ6aEYEucydSAViD3L47cnyOv3nWOg5eQpUZtd8MnhNxqbY5dEIbnxNpuGWYeS4YRZU2LVsLxBJ+jnUXVbSOnj4B1nICEwbR8a98rX4zg71Ta6pW5bv4=
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