KqMwr4fssPTBLfYGWSuyveej3J/tTaqU7T4oBVO8E9qz6toGY9E1CpDB+5c1HOrCgLSaNoWQpzyQBPeF9QLCd9RFxkCMd3nhYHq8MWVLU3jBjA1iu9mrJEj6dNbmPgzEoZ7qLnElcbkUpB8mtiJesXMDjVaNHS1vLv2cLvu6d64/5H5vWM37zfwlw1Gd2HJrzQZAaubOpuesBUSPJkPE/CXeUUudyv1GDeVYkPXhGmAqevuiBYssCXtkSzBiLAc0J+dYoN+n8QY52b4GdNI0MapxfwOJqDkFOup5br7lzWJl/qB+OcLrb8SjFk1wiGC8BywsF6HUBVeenW5MqOnkQrfzUMW8pCjgrWQZrkqjwykNeAL9m0sxW7ay+CTKsjB86PXMnlUCkJ/gq5qAje6LUAWKI7Ih/Q8gyjaR9WyCYz5cQSmibt373mNepV2LBDUvRevA5jF9RlXug/conxe3CaL33Dw0hoY2HtAFfCzoCzz0nKguL21q13o8CTXiyML/xwiliqwHOEWfSGm2cS60WeEs3DZ+FGw/h6+R8kYATV/GCv7+zm/OHLWVWCQU9Xu0By8vE1yk+HVASDFMgQXw+XlLVsSzOyRNCbtmBN6RwQuASCIjdFHscdK7Tp0MBCkdaHwZH1yoIALBonHRJ5MaeScgj699gWPubKwYtCxUJgJaluq+7WpM71O1MJXktxRCAjSzZzI642ZqYsUlHirIEzlZtIB3vBrWGIAyAe8h9QlrZDVX8ovEc7eWqRbxGew2uXQHBWcruGCv1j+RsD2244QqgYONxES0D0gejQPQDXhbrrM0w7Mi3GXe20e2bewSEzmbrII+HoWTOyeQBApnMiclwojicwIQ8+B4f8pH5sLhiidglkYX20b5Wxsk9C8llWZ7D4LLCIptKiOmu+7sp13CwB4dIz7gXxM7IB1HfLuF6wffT9X3l36RKaVnSd+vKxKQG2L4XXMm/GB9oVMnUgXBdJvVos9mlyCXcSWeq5kYhOh5z36VtbKBVOX5GcEMTh1zXKKOomUhLiE90PmjkOFDscahY4Yp9CpJn3j1qDIYpilxUWravgSxx6/rZNnlxRH47op87gVTNjBG3UE9TJNh90HdzSf5YJ5cr87mMH7TRYYYkKr4Lqfm3Fd5NDPmttGmDtyi3O5meayNUx+O4vBtwdS0LPA2WdmKMgvs9bvhDbijPPQlavOFX0KHsIiIBH1YZrkNyD0pEdZwub8Ka2RhEIfRHjPWC+zNKT6FYqply3XEuM7J6l6BjCulwVlA52CcRNJG3hKRj9MYT4w9JyD7+qdL0JOGx1OjTu7tYRHMdrGy5lFSKceKNuxTzVrV5Wyn9OEswcdATMg2xL6vG+WXcEF3fXt0UMPX92I=
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