3vZTNczgzfw50MsYWrlNWqYFHPpiIqFnhQzWHDdvDR0lUtBJHq4siUnQ8Q0LKv/kJB+chZ/ZpAjKJMjIabk3/k+Xe0SdIG2oocj+vRNEKw7+mvph2zeBIAwhFmH0J9sdBRjWnCg8xN3sYf1/6XO+XdWc2V03ggOiGxd8PBsp9yCc5fph0zQUSQ+336LHWht8k6A0N6o8XWudjUlZ0A1WgPfRrvmbgrR3hB0EvHN22D6tNrBtDtPlqvWSooqq0rHl5vZtngdpOsXBZQTBdSqGshPdvS5CdLXu2ljRDN0VYiftn1CE0CMjA2doo18UvsYV5OaIZ/AQFwS3MfTPOjZREobbunyDw1YmTMVQ7bG1l7FBFYMCBfF+VeTTBjanf6BW4jqm98afZHkiaNtRCWQ1urXit7JfBRDx0C5D7uynSTt2GCWZncNH9kXLLKUGJXxZ3AWua3z5jEwzTfnwz9aNMgPKNTS/raJDDD2jD4ONZnEdypDJxujmYdDSx4vZXCanqLT7V3RaCjW8HlD5OF8EsyZpLYl+xZ+lmJa1hFnHljbc5es6dCmxVR7wyJlKZ+KnJM7MBq0KxuhBS3ay5Qz9HAx95QcI/CDNzue/4WBsoTwIp0qxhsIRL6gIrYE+5LxvcMvwhqc83pi/RZjJ/21K1b1sAk+dCFHqrhJB//KzRGWEpUNCl9A/nOzZRg6mYpidCvp5beYJDtjfP/uRwr943pRHjK3Ig20i5lbYXi4iy41DkE4xpKo6eLKwlA7IEMycSvHkkUYTSlRK8GlQ9NHiozvvj3ozULTtHWUCB8+8Iu/rdQi9QYOH/Iqcc16LMLvznuWLb5B8XksGar29O6qTJ6ThtmXiHYPDHvCOKS/NPAcEzioPKOE9YSO653ddYREuAp9mzz7ZA8K6WuPI4WCmuY1NftVoH+8ECWGNFxS4+jHwuQ72FcS2gFtctgFn3Q8Tpj/0EVHJpN1k2f0wK9zAuEfh80f2R6Rai6UuJQS2kcfoMD8gv/M+5/mX98Ezk1LyGqZC/U9pWqGXoKwV7mQGdSRk1Y1I820Lj2FzsGPv/tKrbl0h8jDhgb62MtrAioaP+4qAY07MLOuXK+uCWy63e4krN4paPsVBmHGcA9/IxXBs3Sux92qjhySM6qx+DLg3uGjbAYq9dwREdZQwA/hD8Xlx8Lj9UuRFf6jhDal8zxVccj0F3alM+SDzXET1g297BjgWR3eN/1N+QjFHtYkxl6JsGmlR7zqCINKe2cQ7MfcN0lhmYEY/3bcACPvIomRm6EI5QgDwIvg2Mtb6z08BnyJyOVLBpg7fErnXO/yIG0fUGGMmAHjAxq0YczztW8u1dbvhHVnA34/mofeyawqu0xagb/ZtnZcQ5jkAHLY=
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