sTvoqC+X+RYpZuR1rFkoBcEWDe//q4jNpLHW/ifE2u10HhUkBXNMjG3X05a7DqYGus0TJk57IWJIqaKPNLgtle4TvZoUmbLGyDq+b1DhDC1X8RPcIY9GDhlGVNYC78uvn5sdUOYiu18i3+jHo3OY+4KL1uOA41daCu0W2CtXdsMbwPlSS2KfqudWX/o6kGdHvo4Z7ZPR6qRTnN0DUOlx2L6nM6JWPsaGyQPDKtpdorGNf3JrIPXWBDgvRsUv8hGlhz63IlD7fKBPlfE2TXBLjMUEIke1ZBWUcVHP1K/mIzPISLzcVIZryUJZXMxyxdsHz1/uinQNwarejcKrdoKg2g+kt99YB/ZtCQRV8PwLLg8BeJydAgFhj0plge1c+QOFPboXwAZn5wf71stW/yAl535kI6ZQk7oMkDqQOSOsuw5JCUEkks9c7eTDnYmB3H8WkgU6lj++xrE74CnZmY3KiwwJlmUMEB6XYoI4Yv73862KkkqaWTiTVip4MQFWqYArSo1Zlb27PJE6hboPRcWjPpfxcluxWnenMJXT1k9xoqck2JsmXjc55VksTmnz4sHYQEjqeessj7NnKIsEWfpUfferwRGmVNRa/G827F/L16GXSTZJjOgdA0oP6xW3IXkImmotB8wJbVcvv3kOtQ+WtO9eVNjvdV+APUfD1l6czB0wc0yVlFjG6oOTMhi4TyUj7u1amgZ8sSck2ctKQO/cjfXN25tXvuOBrxh4CvddnlYuI//90Z6FlzUvXpp1EJ7T2xRZXgkHcs2x6LbQAWG7CqHWXPOmf6IpbH9cYCaofI9QOTCQzULEmWjlLAuLeSxdsRn1Lmtcl89NXdoRe2qoPIO/ztCyYgZFJFeVhPTPDMtQuqhKwUC0e2VbQWFuOlja3Sc3Anz/mbLqunlyhv00+B9wcNyq8R6yEzGMABkr14xluZHJDfD75TIa+2tOiD4huf8jw36KNXqNsd56otF8afgjIjxQGwrT46yK+9+tja+YXJ29NgzsYTI6z0lAJKmlGCdmwvVA9kwzV1R1xGB62qP2aUCkT89hHWcQZdFpzV3DDeGPM7WcHmN1chv4XFqZy1dxvB+zrN26AGn9REVknnOFGowf6Vaf0aTE8NYKbTgKIkMrpkBV+jIo+35ETvkvp0dSQGhGYcivCjNTYcRAqx9P9mSelz2j1Bapjx4MjOaF9goIhAImTnSzglRFv/T6JnQSKAJdwmDjKmglTL2+2GWLg6DM79PkH1YYQ47nm7MbjYVgEPY8inqVXpYDh1qurEEXXTssp+FvRcvQBp1vpQL1ToRm50VV9dZiwjefbygz0DKmSv5BOAKpQayCDudgD5X+Ja3DTlAdMxx6aBMkmS+A9ETIF7OCdrWhFQo=
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