myyr7c6YELMF5R5EncglqFgUYMPD833pgmlejmP/qR+wDi17Mnl/f3Iibq432IqVsjTavH+IB8ZsIa3em81zivV9GsFBFMwDWkmFTcEsZLdzeVZwYhiWvrsiktutQSH58YmSRdmEWeRlI96r/gz/ZGHbOmeEvwsmrE807a0iTK0VFS81SHftv23h2L/nVsKZY2yVB8ELiWAVqGbO4U6iM/gLrVtwjcON7Fpz/nvNE0qpNjNfmWmvQuM4gZcynUAl5g8yUh6eRCZ4L3eWgQyg8rN4h/kdtOlmw36zy/Wh4IPvh1eBeby6KU5oI4RwfGIYfzAJj80yyvPOJqbmW9hg7kQL6cmJdNb37KnWwmPfGRiGg5fSUftncUwlq7dxOysbl1KiahGWYPBaysMmpYIq+2SHfGYlOPz4ZeMJ9sl7jscskXmZY4h14Q8oFNWi1rKauBP8P382IJes08vDx0u3XmityLwg1Gkoj5yZbTHfX+dtvlDUk3SVzWTQVEt7eXJcQpuuZOAw8UB0QyHYXOwzi2p9gqoQ08OgYeEuUgwi50wiZ+GyZGmuseBjDv5tvFFFUnYVsFViNVG0gMq06tBxjMw/eqnqDwoqDnqFTOtCbyGAmJJoYFNLGFajc2FYEgK9I1i5kzN0myy0ZlabQB856eQ2sC5gMIiq8o8mxbbL/4FDAVFx3UY+14is7KXvEPMR/GMJQnvxT0EXFY9WfOueIAKRuZOquPVsjcA+gniP54NJVz4LvvONRfX+r5HhUQC6fHe/aFfFToqyG7+3ici7d/m/9ddBSikrH105lgIsihsS+5KoIbAaYGjPMYfDSFYYyK+Jyg9MhJyh4TdRzQwU3JmdDHO7RapzhEVobnzAQ+EzCZ4cTFHHrSE5lZJsXDhtW9aMWc2kO7iuUUusOxWlvuYu3Rxqt4GxdKjwFih5Ftp1cRLoLGB7Cp6M6wnXzqT+J3JktDiyhYga9A6xtiItGK1ldWmvOyaHIFQelfxg943IuLb7RYpp60a2Do62bzzNFF8uENVjsKHHePJ0W02Nn2skFOGmKFMKcKzQPd54g+mp+EoP1tDQfJLVrfa2o055bOVl+l3uTMQIXDUf6pcynGmDkLTA91h190LTqVHJYRxMnXUk3GJ1PJ6XlszKNR1MyKAcHUFGMzi0Zz+lEibZWbGchcfkbPK59ANgY6DZffjzNZe86Cc1bzXKLSQB+3XQbfmTDffQmBMKQQR2C5R4wnRJyC/DeHXe5yHOafAPRA6ZOYh7vgmdno8x8VdE5l2ncNGbMpc2GtGvA1ouB+p5bBBk3cdZxNi0p65MbxIIk00FGlbINjysaIt2eo6MSMhopyzFNgGVWPu2pP4ppdlrVbWMb4T0gBSYfnCFj6A=
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