w9QzEPVgDRgi0aMUwGZgJ2rou5WVkIiuIbZc4okFgLZSR5h+RBKM2lNMsvxVMOOuCNhkgI/2BmluDRCsZXyjP5aV49CvTQnBv9CeS9HNY22a5YEq1v7Ckw9aPvk+QcCWr5Roaw1CaBgQlMjmelnIhrm6j9FVGBoMqJhssvX/WnBUL73Kjy2x1F7ZHifWSD7i7xvh0e7x1IWz5oIJET/H/vlF/tGYUBFk+NI/+KkjoiNpcRWHaW9H0aBeS9EZSiLP7Wn2DvGHxXiJs4bosysLUo5EbTIpgOrzUu3/W41EsDh9M533bb5PZcIXKr5P3fqD/lEQhHmFQyb2eiEu40GV9l+u9Fx5qqfqCYGOmV+yU/4ZNapHx4YlRBwXxx2rUUuoJBqZ8zUcSiFQMWFdH2F7uHZKngrK6B/hOGBHDUvwG+5yH33BiTaD40mYbdF1IE3acuNZrgQ16ftyw0VSiV/GHapb2i4jK8r+r0CvdRv/kkvY/+obLtLgPrhM7eUes+9LnyH+KvbhgLCmBYXPpfl2vQZFVdafxk1So7DBYS05kCATYwSR9PcfJ5BBJhdxU8mqqj2dyyh989PsOivt05+WwSb8ip1dDgdHlW4JM+tsh70qitRdOJSMyzEuzkxP55pjIZhB+28bOauQ97VJ4GiGvRwiI7MSo79ojhg+17wnnvKhdLvqqFLF9f5PPqXrvduDRDGpXb59ASUPUHlkQEBUUywf63Od79Jy1CvwKhMuqRBZ5LuS9wlx7kqTdP47Ua+4uWMgRNIVbHT3Fop6V2p753vaxQbm0J1k532SP84B0yHjmqclth9sIJmbYUaxndBO+LVLjSusCTaexaCb97E+QDhZ3ehBtilnADpW2qVY17+L+uoMGIuW54S+Fd+5dAOh4x4KlhO2UKGnB5N5b+qphQTRytTdaZkNHnhVn3idrwB5bi/gV+nyYaytkIw7yp0LNpXuN+xkB3ft5w8VYBG3vLqX8sprbyMuX0ehgWvxIZ55l7D1EidtWoL/gLjNb2zmmrLuZRFj/VmQXGA/F0eJ8NStx2gNeYrUtouI0T08/p653O3HSm3qHaEmxCoTA2jajZ53v3pQuqm8DA2YakSgelGmjHvrczCjrLuh42UXuLqLfQ+3SS13xhM786JDmUUvQVjPNlEIzjUI0n60F+nD+Zb9Ihkbb/36Nt4PYJ9et2PxUUiy1gAZXvomZcDQ/LzXK2BmCyRmovBqLY3/ZcEmrHotgSZ0VFT9iBH2tuwiJwoHnR1Aj5UT+wXon3BFvuXWC0pe1RYf5LCNAHW2Bj6shjzC4voLLaPW9MufIC+ptB/91NHWDHdo4YiK4s3s5YpjeI2B4MLkGavGGTAcHHHUv/Ln9Ghkl6RhQMs5jEA=
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