iBud7Mygq9NUh3B2idxC8BB+Ls4qSB8bqiEaOI8Wi4uzhxvHqdE7KJ1YfkxEZQ4cXnMD+7OL41RnFyYWJOuRwCiXxUBhIRB6nujb3Pxq6H9kPuPdi5ZJABsZWZp38mnBhLUE3WENBvwhfHxAQYW8rbkJPQZsJMT5RqeibiBVPvg3HHPRYaH2E3ZO7JN7Loz+/CMwgsw5cWcqa46kOTUwwcl8pMMJZt3kicQsn/OpMQq4mmGOeuRnlxLzPcpxYtuqRWfAIXQnxC5sV5rMlS5vlMKTstnAR6LuiU+YMcEgus3Wtje3W2xnaVqUzTtpHOhMg1gu2jBWi0VqOqN+zxM3WsIQafElMlje2DIwFnbnzPQyavd6qWz5vPo+lV6FK3K0SbIOJnVqiUEQt1GbMmNMBEE7cmfmB4YVKn8xxMSwwDKAd90nkzFNw3ATISqY2C4hMJumls1FaJLPdd1frufT0iAixQ+b/VWoz9kiX6SeSE0T9G70GIciSLg8e5CZx0EakGLQZWVhyxfzmdTyjIy9s4T97WlDcjzvtbjNbG9N4Z13wXVSZ+0N9Hs/s41Bz0bciHZWLeQYWeEaO5XrndqNrxyh1eFExWa/zCxh0XZ474Bkww0V0nnHSiZIX09wltf0c+7I5x9ofCsbGliX0uU84OYa0SmAiEQquJaTNwpz3frFyMDCEgOQATXCa5RdBf9pvBbqfeuCaoOKtc2WojKOetwYcV6qk6Kk3F5l1vUEbhIUXwl6w08pmKJejx+lUtAFeajReXT5VVbZRdsnZPuWKBhtsGzPpSNVzRGmNbiaRsb6xlrsJhwHwq/ZhfYAR7pG/RGD2vzaZbF90lBG64LgIY/oO59Yy/PrE4+XfUe+BPV074D1vdcDqHemIm9k6dD5u3FXrHBXQk0uC2acDzAqa+Ayp9JKOwGplJQNNcarodihJoLGaqr3XAWxxOy4mcPqqfgXTAY++dAjWAf3v6uApzZcSVoyllPad2eGYLspgfXJwtdlWx6PibSbrNepWwFDTDDa+HWLm/HTKWx2nOvhEVtG3f/XFEpN6zUhtvIQJWHOLpf85QeY1h/qQ1c0F9wWaTplw9OUQd72/tGOYJiSGn16ix3kEgyIcFxRxLX+s8s/dj5cbIjSwrj4W+wnr7LWNu/Ne3J5xzodUD8/mZzUkBSm38Rd/eb8cd/cDMAuAGBytz7tJY3+q+hr3IyIQ+jTJuPNxENSD6W+1o64Wk0ZsJlJlU3V6wy0mJr+Li+D6eAfOafcuXfuYeJwlcyXn0kDHLqRPhA1ZEtSoAVb0QJUUw+gpevxzlKol8PsByXpn6oCx+RqwKsMBNgmfH35laqyLLovvS1PP157jQjIaHNWAiLp84SdMBh8QIaPyr8=
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