uhPTGr9nppYKVai/a33JxUgytT2ODXvDVSEEDe6gmJ1sqqDnB5uWE/9vzWwQJukRBlSWnD9sMBxvP3k3HASllZ083i1rTD6kpPjkf32ZYJpGlpitsL0bU8XO7XTyEIyh4aM+HG4OODU0IDjY8u9oT8RcANq3e/067GtI2Pbc7tlRPoXh2xvXIYvXzWvYc7pIdDBu47S7zX6w7kzpwYYSRI7BUnfa/J5mK9bRefrdYK0XUvIpU8EuXvfkfwMXYcLV0GZqn9LqIxjUtjulZ1Mf0kMWNEtxNoumtTiMi5tkbAKAiGkwTrOZqheKDVuXZa+QtT0TkUkxpZ1ARUalMlR6fi3i5idsFbF/dh3uSs2IVVbGqRykbGENAMyPtwVK/V6ol5ylewevEmJRjAQwCNZwb962MkhPXymT6JPr7rgLtq9VUZ7irQtCHyZ1yreW2x3TYHKtmxEXXq+dMN5WsiwSzjtnQiPKFREr9jfERPLTEge59wl+VEJwGqqp2WLczSqelwpHA8kxPF7VqxIWhhNPeC0vzHvMyc21b65DL9AcJ/r2WbW8OS+mN7ZB21JaKMSNAaxeo2MphA9ybCckejt8W9L+O+cKGvQC8/vVLurIHVHGs8DT2paB8RZTi2hCv7kHXaHqlcaRJoOOyYpKpkiMLakBsFOKkjZDF3ri0s56crOyyBa4JLS3Gmyal+rfdQhyLthIJ8sPEjGd5UKHLJwQVPm8cfy9s2WbHbQbjdxQxHJvS2I9wHc5/1v+1Hv/BXG4/yxmL2UZBjJ5XpmP/QxR896cYlml6NStd1mKeIycWMbN3Hn5KjwYsNp2eiN+v9iFlUgC0YVff2YFQ1Y5RB3v2xlnolAXQYX3BDZ8+9cYtDrk/nP6MQs6EIPGo5aFJJAtc21DPK6gCIXIWR39K4/hA7bzUlf5fTBnPE8pzAnQX4Z5HlUVkbB0+YlAqtXoXyKz3ap3PeQP8IODMkBefITqoJBRqKAyz4Tqx4dHeiLUsF/ucirnYx+aYWR+CYci1XL5iWRpLnORKNTbWrvA5Qyd3Rsws8w+UNnhuADyUYlnn9TZGDieLZRhCIIT9kdCKQgkxsAlrg3DYyKjIliUpMv80Eb/L9DEst9BgpqLv6KJ+pPzJaXNOK3S6AfKs3wenZEDDVv/xOiy7jwcMNkQHRApfG13WQy6zurjnS283wDevv3rjZxdEEvXcAtB+4yE9jcpjmJ3o3yrv4qXHwG8HRHolQlNPt2buNrpdagOiCgUH/XdWDawA788JnBmoPccXdTocQz0dLTRWF5+Ko3MsDPEXEhuFE6slsPMOmXKPdNvWP8zf8MnA0qMdRw9DVAHs1Cw8MO3g87nzzJNDGG+gLK9NK2RTJn6cOnKTQdTHRE=
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