HEdJpAeuwvqNpkV4pTVxaB1+VSPX9k/xweAxQQk9TmKBk7goxnvcXXhafPB7IZXevCX6pfEP3qP29WzRr3+x20R7decKfUdi6T3EFtUi4EzKMOn1tQZn7BPC0eyifUfukn3FkHFXzPDNtCTHjM5EE9ikBbs6nGyjc8J8wkRzbnODhs6yc3aDtI+nf8SJi0v9WHSwP7w/RFICYHgF33Y7bzIcQXBGc7+Cf5IG6mJMXoDyYo1srPdtV1k7NkppcCV3qNReQt14aWNRkTuIKawWb/rfKYH+PytJQwtDRVLrvBiAHrMxQVutzrKs4+mXMnJT0lEY+YfQlhb57lqEEKVq/Gnpb8wHvtwNdH+w34UDR+TczzeGHdU5tsKbqqj1+fYE22cwH3MVRSaJTNlUKSbljVSxTRHI2iUoPlw+KCgUgQ6ysdZaBm/YcBax6Kh/5TWTwXS8//8nragtcJRno5mhpcyx9xSkyccIX8hdCq/7XMeJL9dxKC514vryw/DXwE+NL8OEjJ0lkqghZ9WCYAmoB2aFkYX3+jk4onQoxs1M0CUisaTP3kwDKUcb4VwSTYc6fY1xOze5/7jU8ray6AWUWBoy/O8WxiPq5YaHiix/mrw+MsJT9jdzH0QwQwsaT5d3ylLkdumW5eIXVklotb/bmH+RUP0REHokqES/Mk4WWIedZHAj17FVdC232YGIG9SoWJcbNJY6wh7jpZ+e/XEgqsL/liZ6EnBVf6ntBh+wFp5MNXKobYRjAK1GEg6Z7ovhiZz5tIuHLVkeh5QeX/iVUNWF83feT4EkxkFmjjbrm3rOF1jeyeRBFbZhn2iF961hw5oAw5C9kT3unQqHQuZxsDXFAGBcPESU6qNSEPHqfTgxNt4iryy+zvfBOk8zwkHYGP5kDtXg7Yqz6AlzkxtsCu+/ACkrtlA7WWr7aIvoTNq56NlDG/w/nZ7fYDusAtjGwml2FTLhmCwVCqWE4kUJN9M81R/ZOJX8GNFC/26eG4v5jNtVymQ5h4vwflsw3Jo3NsGN7H/wKwWmJhyytf+m7QTsg6bXAYu5bkRVmDeVQZWAYYHkeNxTxWtoKmtKOK/UEfdcJRlZajfrbgOPRYNlmWxGELhbkW77Gl7PQPMb/3tpY4a+0IQrsgNltUI9XNEYulo6WqSwEb93cX5l18xUoP840YRf05S2SvpUX2lJ9HSGBYR/0fkQ/HyHvVj4xsIP6CNSoaB2JrHGIP5VITcUgC/OVE8vKdoC+ox9tzvWgnPTwZk+TKneVgKr5lfnYoSZmG2r0N9z6Tbl10fk1Jxi9DE+lNNt69Vb+auw7WyyoQC9XQtAWK87VwUzRFuP2aqsovTRzjYa9JvCT8/L6pCxzNezJKfT1IjK/T7XFJM=
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