mMh8S/FGyCNpmT+86aMs6wBN7V1/eMNYOaHp3lpm0yXrcwEZIbXV4xkou5TsxFdg+J9EiWxC8093Safj7ZW49QsKhqJmNFPJxdQDhtncBv9K1m02BW93UfJ/zx5b6Gg6jXIOZl7yBLC6EheTmJpnBeaVaqBPFNjxLv3euz7fyAjZPUJy+fiWSNrRUsOQX1Nz2g23hsKQfB4gqtHMbK5LFIMsmsQNtMkaKJCW890Ls+u7q4ToAvPJCCHLtk9LTX8zuvX/b30cyTHqz5L9nJM4FxgNwzT2Lv0wq6HKip4lLJj80zZ9CcM5Me0KdbhjfcAJCLY+JBUzDpDzVHbiUpSwkacpLIjoJF9lW1voNMrnO5wuDVhshC7onGkW8Uk0JsaQeBmpZVy9bNouF53PeN2wTyjxf7qHEkfYYHkSPhbiHIZG4ZPb4RGxWcHok8OqowFlXZ94FAJwHBfVTZS+31jGyfRoX+GYevQcHrZivOVN161WxvVsY7787A79RcyqDv9TJrC9xrpXhLOL4Q4k+z4wVA7q5FEouVZJSigrpbQe1eUPIEeWH2eAr6ms7WXlv9fFOPFi2qk/wd0h7F5UNSCjrwUmZiz4HWbnP2TJxQKGRWD1yrvfhYr2zVadjBcYvTMHif7TTQuXK8idK0ZyvBNFi8TIFOhDOftDHQyeB+FkxUBJ1KevyAQ2fElosJs8MUh9aafKlKOcGS4zDxT866SpZW6JbBheBk6JL8QUoLi57Xha1Q07RVnm5MXQrytSVsx5gJi++CGfsnKwyE8xiG9EW84ZIzPKLWTjQlX+0WqKtWz1paETbtAIi35MFvPXfE+E3WySCogczOwYozrLQbfLTUeMa4l0itMZzPZi38WjyaXPfjUMVNwgIhsSChTksXWZapiLm8BgXZkAr4YCPnqJWOJK/B8SAFAzM4YDCURXPOjfIHwzkKLu9yVF+BjJh4xIh2Ve9+M35ZMfBygu8mivtB9d8LW8sul9ccgireM+cG76bN5QZgH7mqjc8eihCqhiYKkYkzsEf7onWl7SC/SF9PCKNB6zGUYV3/gVLLfEfDxMPAJItVzLzYtSkkLoLk2NyMYzhwBQPtOJROY3aTIK04udjEeIii3m+Wun4kQIef7gmpl3P7LQEqNNZKQ0aOI4H63l3OLctDE7d34QU5WJ/nTE4Jva1zFeLozGCsan83HdLVl41X+yeYyac1xhIZjvBPRVNxCwkS0K5Jp2z+N/Zrbzq1u7Dq7hj61EsBoe3rFIm/3K9H6jSgBLvgCw5yOd7dh6thQvsTRUFy3DjhPzqFTVyrywKhHyLDCqpKLjcbfEqD2aokQODjAyQULZkg98JCAYvz1LO4XUMEZHIj2OgowqQy9dcWmhAmJaNGw=
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