T1/XlWPxY/idqDSdAFJQCSoXxdq7z/xOHtvS1Jf/pHATzFKZBUBmDGAjCkX+IWSmonmyQ48b21kSCpGlSWmvNBjQP/r+RH8oX4alAFKfZtYKGpiL6gdCj0H/XBcypVRrmAjyE1qUKezcPfeLZF0sL8g0BJoMqXguxnX1OcS1pDaQrBL9FGMLXBxS0vh20+zEYxRW0hgOIh0YBkh/uZGitaP7nd7xFIt1VHypgX8+nFa0UZBU1OdkvarZhu+iMaccqIqfa/tyjZo9mRc4/A/e53YZ8lfCv+IwSvfjzjf312wkhhRAWRrxVf/z8eTfA5EC7EWkaenuPvbd++zbJOvm1diF8K5/BrDMrzvQvCtL6zE3ZJJzjZU1Oy7bkZ3zToGhFzXca2HIksAN5AuDqWzt1X87QpGDULqvMVds1oXjMuVzhIQ2MdvAew6vtlT6Vtji5AZK9xD4YUHQp+R4MeV+aaqEWXpCPHDdlB1v/tGm16yZ5wOHxkHMFuodPxCd0akGycB68+Bt8tACpeLpLttBR7ahY+yKhKzLR2FFvQP+jRFoHWbJRMtmT7FCh4UZuDxf6NEncpkFbuB1L3Un0J7CpjXNlwmKclhNRv1wnBVf+s1/hLMDnWEOMVltl6ddugdAczs66SZ7dqY0sr6SPxUx8bG88vqSqftQrHOgeZb9jLC9qpOHVnRbDsKOIRIH8QF2hsxFWFnUbMT5pE96BZABHo7Vw/nZyhNuUEgr4stMhMgAlU3Ap1GPts+l0LxQv9ZChF8vUoyT0S47hrHGJ759PTUupqXQK+0syQ/T7F/lP2zY+KAwMGCxlmM7Yyj7FEX+EiQAOv3R3cs8JVYoNnbc+fr6hrpiiLtGpb6ZHAkwAn3JhwNpRyKfN/Aio052QXnSeNBOLg0odBXXbRdPg96IweB3QY8q2lteeoBTtQ5qNdXq+yvqwdgN+0YZCp55mdtJRqWnWQZefa5PrhNmysFw0mBiQmBfmm3wmP70B+/yLh/4Ot9onxvx3VjqKgm51vJXHXcStR6oC6gY62PukmvRVYBY0UF+wbpgZ7nzfla83epmw3+QJKKP11b1l8/TvBam0bip7rfj6VMuLYHOiIP9f66c/ZAX6F7l+IWqmFvGoMbiFn+7Hd7CPbn6EmMyPEklCtpy7IANpsKS8mH4Byunt/531CLKyBGt3wuCWyEu+tu02kEZC6q2inLZy4I7lj4uwMilpStbB9ckcLbJwMfwaS14wSqU76qUlb3Ok9tXYCEOk+7IXbYg8fGdd+p0HrshF6/jl352UtGYmaGJbGDOO81LyB3Q+YfJPDFBE6s8Z1Fa+GdjtT+gF67jAwh/oyCUGfOxfLPQOg13SE8kZqV0vrt8Ml+kSnVB2l+MeUxNdDA4dpOKvx17umIFbV1ZvGiSwuDTujYZJ4Vf4YxRqF/h9mWdWXxwLqfyS6+aZpO6jzXdSlLI1Ke23H5oZ7BT38v1bdKrgx7Z/HDnp9afRnFZKFz+VYqW4MvklJKGqcJKB2FuSadCs5OFCPXMMl/sEukckF04ulAQut5z5Y0VkmCKZoXnRwydEw8C8FqpHoCYfgKRkSlELJptw9ABFmUGGntZNjfCqWlVGzW/OMTdZXbgsP1McNkmP3OyAOlDmUQW5DUwU5Ju8Udfc9sBYwCxg9BeQXJVqQqPF8eCXjuo6o11DoxR/ztkU3rnkhBFgeNFd8feY+/SCa3Hw+idezA=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100