GGYSzFujgx2KSbU6HbvAAodxxxHyw4Y8dqY8/NhMwNaakpfXq91KQB4FZ+Z2SiLh5Fjy72E5C10bTSNhQKEWSgB7Ryhv18aouPnyzcyW4F39FsDwoYOCNGuujy26SOWFO5bBPjX0pCcnPZmPTp/QcNU/s+4I2xZyMpQp1k2GUHHKuJzWXcPnT/YQdRNQanZHFJhnceubZh6w5VwSqBED8Lhdwaz0QnaWXqZSJ+S6RQL9E8AkHop+O9ihvZfVKZuB7uXJSeetUV7pIaqGe5pn5BAVBu+3mn1RLmEatilk8u9Dfv7IXrLv+fadK9xk1mBeSmLr34/gZkpwQiXGUYtt9dKkpkI7uKdZzMoQ9N4SD0nn6pvNcz0HTlEoVajfkHseCNLJ3Mpwvk2pK83vYze66Yo0vKy0I6SgzbbrUfq8+lGqsGFcylg0sK8TphAQBsqH610FlY8c1MnJ9qoyKSpNQCS7GePP5FtqIj66COUdYRWMnmD2gaxLpWvZbOq6hXJdYFSbYcICDZAMCAAM9A1I24Xj/Cp7vnj4Rp7n6Rrhy9eb5MxzYeB2tNqX7A57Xo9ord0m/GkNvO++WH10uAgCwKNEIHQDcklBQPy5OtURg80joQSQ2/Fkf+WAQm/aMduabvf4uVcqdOLARVJ3h3/a+ilFzZyaa2SRdeWYTezxHlYMipScbf/gQpjgZ8hJKjlsGCAOmHfdtJzQuDZY1YJ6exnd27DkTWQAsAXiRwCiA5umUTCDSnZr1npRaDbY6c+FRlG03+YcW+LCX6py3Q89Xm4Ie1YQ9Q09VIAU7+RYjjD/3RPJnA7K/1RLl2+T9bGTJKEL+CjSlPSwPc4KJ8D7zKYG+LCQnU+qeREU3lw0sYRQgo7lm5N/G/tjGeZSWbjdrXOhq0+Iw7g4qmrF5RHXYmoBWbWYU6lNFX0/hcChrKD11IdmVpWg3KMnhK1dUa00ZBS3fIV5UBSbD3lBNOyS299QhLkSl5cFOHZxrF8tj+Xiyf7L6lWMtOyeUuDbgewJ9MXJGzPPw5YUx/za/K7e0G7jZss5954lfRUM2nlLpcQZSSZlqPvSvyhp/xJ6jWTlmwP9HhwwHygBdUoh6Ai411Yoomwx7W8epxZtaVpj3CSWhuoKomngZbi4ag69zAfkA54kclPESMXzMlm6KeN5tUmYVKmd9l7X5NPCqkygW4gtD6ZQFdpaG2kleptwS9VsmRu/LnulPWcT//9ChROahP/7B6KsYnEjtAWlFpnxtvJrBT6tmPBcfqvTTUxyeidm2yRkOJwLemwNiSyPJoWvSXWKL6D+cirZqQ6y4j3uvenJh9Hs6ltzBi+2rtUueDyaDtjza0q9qWzndAjMc61bEFToylh+1OhhgXP1hac=
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