JVqjZon4IebSQTpFNjoGXNFP0MQSNj9Zj9vzSm1EB0wZdntxiTNcQ2vXLqSfdrMSSd0uu5f88dkWmdil8V5kYzCcdmdMxvusXeOMnd/IN9G3DZNLny0WTqc2nSxMGFwLHrd9uRUyO1zWJP7Oe73DH3StPQes3LVIlBT2mK5ae0Zx/MIqgoqww+60urP/bCDRl9WbAoFhq3jW18lHG0TVcVbwG7hOp2fB99CGnLHIznsP+DoP6hpAMepyii/iZ0LhS9aF6AT/PHF4KBYOx1zYxkgWSdZ4ehEmEVocwV8y8LL6GM0tIn9oGCEcFeQUrod6gF788/r4hEkqK3brjIRUZ85VwcCCNt54l8Xa2vSn4K80MH2mLMFo/v6m4ibvqGxzZof5yYd01WoYsLAxBOp1/p29mU5enURPwoC/0v+Q+5FVha2AK/vmECIjxIIP+gNOlJSmNx7a/jy3dqnWu6IHVMFWnIURTWTkSGXNkqM+nb7YxomtiDM42l11pEIf/6+qnGTx37NqIa3YqRoC5CiXRVgbu2goT5xV1VhEU4tpnX7jz7jDz5KhbTGDHinWwVIdaOHNJ8ezHIlZHwD5+PCmFp2nKoqsYiSrH5OQucVNNZ1JeITn0wKEaGMM8n5EKbxBwNKJSfB2/UltgR8s5H+Mam8/Tg9npvDrEpggKyE8xOAef4JoCOO9qM5EhbM7IJb/8WN/N5caZCQs/YPYeVqr6bLRbC+VAZ0u1zma2NJQaNocxct2uBcBHavPbdY3uTC1BBoXg27uVpmJIV/vXCCbYg3ST6wDgRMo/glm2iOZiYGoes4vi3HijPObyNpKeG6gpVfyyKcUJNZSJYrhJ4rrdu4DhTsAEVwvkx2fcakgx/7+6Irru1fViHZqPDOMcVfB5gUpJOT6nAC6933U3yBqKQPZAnCv17P9qnvofmVOXCcImjL8GQqSwqrIrNQ3d2/X4wR0zcsexQ6jPOmlVgO76qWL/CPouvVV9BkE8jMuLuYXafRhUMpdXQhpsLAIhRu2bqu+aa1dmD9tERUIzIUhmTFmPmpDFFHvLjc9sPQ8BE2SgymRjGiXYl7lu5bhyzekwVncqFciLuoa6WYKoerFGGGIvqZCK00cE76FoGjGCx+OUX+RyTC+UuzRAiYZfMHh/48rJIzkA9F8fcK0EL+iTeUFwSuPtZdqLc8UVCiswRmvzbVcoIeKgy+IqNpGxSmVLGr6IGpMM73S4lcrkuvFbCY2DaPwIMz9PZpnawV7Ec4ukpDOl7zSfB/ieB+kDIG2gIYAFlXVVFEbOL6C87p349TvDyakIQw5vMUJxUGRb8JihVbNM31omZ9tDBAMcFh1DxlhP5ZotvXkdNu9R+gI1yRYvRIoLWUi2V6+0T4=
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