n9SgBBKkFCAAU72fZ+xEdVMwezVyYQJNDENKT6fI3va0PpShG5vXvToBuvLfkk+nkLFBgsWS7800fhyIW2qYykgCsbKSFlARhCLYFt3QhchlOqg0phu/TqTvbZedwuNlgUiizVKh+qKmm4bWOWJ/e8PFZpm0Hif6HugwlRWjR9gZ4xt7fL9vxzLwq1WyCgRSpsKK9WrnDzUDFp0fKcCNdYIYUBt03aRiPos6mQpH5nn/kv8HmUJRrTXKJu/LlzZj2kXC4gbeLB6UFVeogUJwsx6h6TVxmQqGzLy9uVL3vJyNvjqVnQGB8ZvzCtVBbW6LMCUTgKDrwIBDPqDIs/eq9b0/DRYxKFNTZAOCucSMtLRa39xHSj/FHWuIxeP6YsgMS3VM/2M6fCInlF+3yYzEqcbprd6ghgJXReG6RTr+oBRNWmPn62NxX4aPtKJch1bFPdsMKNl+Lqlbeof1slrTPs/vO338ace/ZSPdB/6tDjbkEIr7Vd0WjUjzhcCwBqUA6Upp7SWBAwnn50Lo3Ahoid9vevVAaYX2zx9fueLIHGriZMFG5w0kc8MxojUa1RV3/ACGJZRb10V6WFQpTQXxlqQsWJArI+9wQiPHGOrYSUt6BCF59Q3+MqNLUUFIf/7Ry/B5bitKcw9i5q0z4IeykWO+UbOjW5/XCOwQHHxeCiXRzZ5PMa2SzILEpkcwsR7329GgYZ2ZIR8vm+Im8hgd8qgDoz53R9lFX9wbO2mLRoQO45bJKzrbQa4jGaiHmp8xGIfK9WVq0rcQG3XiRxyDMJd710LucMhiF0BCC6p4NSnAJvqDyk0rNmAZ/tNWTVojRtyssTGZA/vHBu4TbV7ez/x0wXiAhtU3geN7Lr9DIQfvjm6rGxiorf8ZIeYxoUAIyo2YSH4DN53w7aZo+ps8qBQiI4RbLcbcjg5wtIKt4lRdok1bShecEz7Un0ZL4CoEapLRgwz/I2AgPGDEbJG9auCs3NONM4gItB8emYF25j4Zr5AhIieU3t9oQAjKGvrxXoGjKHY0l5W90EQApu7h9Le5ce3JarOzoAoq4VMMgaNWQGMzTNX0GzAwlGhL+I+fZyqyR9t4+sgTgeQWCoIOIIB+kVoH+bQesMtsTNmwOssZbwWpS6k8BMHP2EViBVQDfoXLX+45wb2iBWrOdrIPp9Ag2neqhxON8Hl6F4zOOpJOf8B63MK7BWRPv36KDEEviGeSpThnMY6CPXVCIA4mnOrFf6yc9BToLPH5kqGTh+MUSDSXJA3Egy4uQl917Zn4OoWG/yOZeHA6GpuPth+AmQD9+ZO7EVv5yU3L7g3HU8vMUJ0SZ98e82hnkQlg5gEiYt+DamzVCIAlwGco9GwfLugtLqvUNOZw283bRYQ=
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