uB6k6FoIR4uPDtODO9jFZ+xGSIcD8KYRa3wvcTvrGGISOj8PXJOjvAk6yuqUq8+t6qJpEsMuB/Q9HLNUoSkzW4Kvp4VUQTUHp3us+6s4n5urAyTvJPyUemTtUa2u+igK9mz4qHN5arcwJzpz+VLFdCqe1k8ujghNJ7MuOI/tE3JTZp+xEHg6sbYs0Z8tIj6A6lEaceTYTwQKX8idieOsWPorIlgDnjYqHcWCFAo60xezeZdnI3xRaXXNnFTlDZ7BbFw6PdaSlQhxZWl2VxOgGyMdpVkxvPTABmjaiPpVh17WbZgqDtqluwgLODYOpXMhaz8bjrMaPSDVucoYgmaqj2W7Fs0l0EW1bO4ZNMwD+ZXx8EWzBCCHiTgZTBrRlV+9xyWf5EKwGVmxey5bIyFeN1MBI/JUBObAHGkH2t6e5GqnLGqB57Krawv7+U3Tnt0bePQ4SMHMVUI20vJUG8MvHssE9o61Xf9vOwmYHFCb+pKb0qie1QjIIP+VpWDGJM9U4vgp0KfBpV8JWLasyRqWxWJEKcI6zRtrCtQwUGnBdfmtpZrV3TRszpm7gItPWno9teR8Cdd8Aqr19Ygxc1aqm1qyzB/xtiuiwVEeTm4X7iTZrbYR10SlT5CxoQn5+hFr8V3qhaNYMNg8erE1i1MSA0kmEHlkhNEpO1Y4W/90rcTKX59dYLT0vGmLF+1J+fBoC7YQB2b6uCJ7bCKmCzqqO9XrbvCiCvN2pBtSZ5I4sy4qXHdwY0RVX71pNZyP6J3qPKyd6oHsHveT8eZ+JGhM/gj3j+Hd5c8EqaYmIdwRkyg5W2HhhszuUA3brAS7t+L26Karxwyu8+SBmmdIjeDz6jq+PWMLajKKAJgz52XRbjP/bgM+3BKOoeC6lLba100ZMcE9b+qBGpywL5rXonTF/KSwQU5oq9eD4mMuMZNaDBTecxzrt4r0lPFIFIZJ5agelC4HtBkr4IS0WrAAxgBQ0RdqqBppy1JsP7vY468Hnxc9+L+wH16UVeCb0/27tQu3MaN6al3tO6VY0TcMIrjcjGill0geepic37t2SAb3D+aPb4gz8Oi556a3LlonnI3BQRGlWc9OR5QiZUqC3eSVX8JsURe0yovH7/0UWOe/VajysXlYlxUdhRXCmyk13A48XNba+BCm/Zbk/ozYNirmFPVBfp3JdglBUWqT+TPznyMozZ/hQxRIIHDXTfzD8oGAp54oA3bGgismEAJkuROJVhIe2HERbaN6h2RtcgUIISrWgrYDN+6fWhFYDCse+11pbnuVMSvPvZ6ajqbEcGbX7xCYBWH+9Kuzbf4lP8tw7PdJDNIbckeAXmv1l6RmRHYUymcBkiJgRaA1/6H7APW/FYV8hKl1y6/9tykcW1g=
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