pK7i1ln5yDGv1zp3Frmr5FR4Gsfyz4aOJjBQvcXsoAjhAXrpf34uIUYYB84Hsv7mFC5aHqGV6NNZphVxWVMdmxDSTuge4+Fv+3taEGsFyZwL3H5y1ke5fl62lkJs5M5wS8JmDps0noFS/dUEWAYi7ikYoiRHK6b+RNxDLh9FVYe1JkHmN3QMoVRK2IevtzzzHXzNOQKcSFd0xTBP/nUp84rwvbI/wwEDU2M4lNWbMQe4Tp8AqxdP9vVUOpQZyyugo8a3JI3IY7RoG+UjqYWrX1JzxrVvgUCNWJ5TD6U2lRSnwA0YHsUMxnnXRcAfAnB+nc/Fmj2i2nrLfDzqE1Uuh83FanZXqfTHtzhhgq6i5X5sKkmxojk8nNZrXd7vMHrwJ/F36iA1tnxgw6OVWq/h6UsEuZtsWM7QuN2tLsvIKcYhTYymVsuJdHAMTGiVZbOye27lHanDiE6zHra77bdcQMs4OYfuK+gEyIHmNVZm2iHh0Q6PnsTKsgnvBQ4OLdlg0btUr2wmG5cG8VG8Xbk6OZgAXX0hbJmNitJJ4nFHCT7XzUwkdxMR1xRZhKLVBgQL78/+RhjlqWypuezaEEyHWbFasjkvfdOPrc/Xi6JTl6re7UuYnURbmrWJFiXDETXNjU/23y8+7kY9/Nk2sAlmHuTIHJGgUkIs8XrEy0DCuEQ8ajI3CLs01fdZeBqHU1jGM2lnmKv6S/hI5rl7YQQAirpHCk6+UjcI+wodUvTlzS6n7EkSONSDWPcXI26RkqNC0k4INdBJVCvHjBnSxu1xlBxpPKEmInm661fVizlxdVcWEStpBupjza+o/RBY8tnJU0pWzq4r2DRGQv3X1++CxRxEZhE5sMMtXK6HxbAh2piO7Dg/LLFjP7iviiE89K2sEDpijxWw95wE3MoC9j+V4sBc6Va/NZqNCGmLloJXLHmCRXccux71Vy1k7c3zIkzGarF6ku3HgJMSD+SRZlnfZWJ3uEsz9WPzIxWZS6u3O5tnWBpcbTG0CAlDXREaciWRFn9NXWsp7bakPjkWnET4NhjLG3E5+/QndPQnvygMJMMlW9d6/ZLCWBQ/zYCX6DG9pv0ru5LVEzKdqxFo+ItNIu/6n9UFclbDl7IsijXMllHqq18nrxFpsXLhVB9WD8mnTvFxmO886KW5MtUDZcdwTx7SUZaRtGDftHD1BApm9MIF693e17ZQJv9PrqGAuw7qcE86CME7DyesFaqsVvFnmc3max4FQC8wNcqLQdW/nAEOlcew68fE/hE/YX+Skdq9xUaebo8gPhxmvWYEx/B0h3bZUbxyWjxVwxCHRmusqSi5MhisxNyFKr/TlxnM5jl7tobGhiOipVWRL1Q8AeQZ8uN9bvGy0wBtUfSqXbY=
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