FW7XOSlbtZPCZMhJypVhws7BnA2rcEJzntnSeTsMEvMIkaqj1FZf9pqM+7SteQDkFgf1LoD84TtjjJLq8ayBgHO+qGdug0K3zsf3nutigq5UcPhKrSZ0ftPXM+ej7biBVN9GVKLm6XErXn/7zKoLHbQauOv4ynlHVmLgCoRiyCjIwAxEZY9q/+thWjprOSh+egCPuhbJkk4gp2+yBZnbyfHM6G51YqER0PHBg5N0eEmQqqyCgoc/wyPuHl0VPhJ7321eHAI/xF53b+LkNq4IDoN6zilkM1hDUuhwhensCIVAB+wm7bLyXHEYbxanYDBV8M84MfJabgo3nDXt6S8O5HbG3imZ082E88ZGtfbroLYvqtC0nCrR/3w3yC8yGUb8osrroTf16Dixt4y+acUi7EnTANp0pO/QJbhkSDT/Js55gqRTG/QmdSNqOg5hU9n78Ong78GShE0odXOgnqa3vDo4mNSBwBHwLN7g7LetM9cMFJ2ryn8uytQ+yUWpBuaNNswkbhIb+zbY5ek7T7z9rFnumNUw1sB9nidU+jxv9COjLdI/1TNpOxFxXi74NbzhW7uINDBl3WJCMfZSG1JCHsV/5A5boxATxVtwDJ6NwsM/ew19UMZile7ASXd38x7jQjnproxj4aiWEqE7mnD8lUhXb7eS9MgkL1G3ljNcftzLjXCU0s2iUHRKtPbgkJsGw/ECwk1RdwnczLY7O9zVkcSpQn/KPQ5dmy8dytU5RBA2/odU60KG6uLX/LADrLZw+YBO50OJAPXbOJQgYH9zdaJE6xXrh/xeaVGnPEt8Ec63amej+cGqwoB63MvuV6XvwwDMksGo9nIxTHrcgXpg2WSUFjnsR4aYwfuEeaaD9pOuw+aUQg/pm2QgpJLzkHZwh8AhYdza4mRB1K6mUoGQwN25BZUGgwfiA0ZumXgz8fFdvlAoDE5g67zKACGfQGvfTv7zndR0FI0VrY+sNAQyoj4JI1T677l6zrQy+NUptJHd1yhsaJhwC1wKpz0nY92ltGG+4QynVY4BR81uNFCVLfYoW4An4fyDrh4ku9Rq+anZLOIgXxmYU0SJaRsTVUGMfYcME23nbgWXoq10mUa0+q1x1QH9aF7cyc6x/HiAtewzsP1W6yKPPoGSaKZraI+1+wHipjKkgQwF4AYaLaeyvicO6atZc0z1XErR3eWf7t9wsEkBNrNlu81/bKOmBQo0wN4/VjOpmKVx8a8GLWy/U16vFrl6hX9kkiTs1t/iefOknEsyojyxwELrsjY/BT1jSfYZ+6hYoiMugSYTO3mrL1RmAEf5fs+5/KtF5S3QkxtBk9NKeqDfH/WWVNLQItR6lV7RuVvtmxnf+JoYvaHrRUEaBdxsxrkwaIAutl0=
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