GnCGATzKKQTM2hp2NomJCyFRF5k6wgmHJl6wgWYx0YB0GMp10PbaE00jxpmAXeapbRY3SObmBItkKf4jdZK35H7EqXVCyJYFbb0Lt582TM9Dhax/ISvCZr6esZmZF5h903mLyViLLww57f5EniqWPubYO9R3XXjJ51CnXXWiOIYTeAOl8YqIliZlGZ8jQ38AoSSDRDsdz1U6TSgS87av4Jw2JWQBJ+CCr8VaABTXs3anXOIRfl23d3wfJK9Eln7pH07ilRlIgAjdDy4Cd6D7ioQgwJ8H5PYUyT605MGwokLEVJsSZ+St7xPYeAwXqi4ecSJEygJ3ALhrjfz8cGxWslYUIRTn8yrArErDKAFDT9/kaNIuCXdsoK3e/DMY+OLyuIiIZS8hgiAoHh9ahxSUVj08OGJp0baER94GDLJM4GGTTYe4IyJQimP4ZW7NtPoSn+iQftEYBzGBLRTMc8YZE/SLIs8qswCEZyIY6Q49G5IUOJvTCoyAZI+1+k3Wk1fM+c/9trQaw3jCNj+qNqbxBVZS06URuUZBP4Gmpy3TZlrdP3o5996Q1+wXGYq5f/ovY5YUn5bMvIWpqcQWYK+g/YIwMvpNqtzRVT72i74N5dSyq5kAu2WZcB+9ToK7WBXXc09qvlq3g4YFQoJXpo4rTmnIobrEbfKVysJoLddIF/fNNUFpnGX9yJIl2luhubTM+qpvEBXoKxv5VM4nddAddpQiL3THy7UhDabZCbvl++ce6yPjt2PL3f+xtDxB0kbDK7CqXi55K2iHMOza5IDUU8Sy56ukFYehmxtp9Qk7P/bd/nTGXjd2Y76WVDVj7tCfE9PY8CUmYs9ZT2MQrk67b5nitlbKLDC6l1oaB9s3ULr/QQwqckUcE/Z7tK7zSPJAf/gnZG/ezt3IGq04I9aoR0KLfeMJAPuFyrrlYcvaGmVG0touSKHbL7pddcNhqPfbAZmxDwTbVsgiQwx6IgUGnDh3d3gysAoH1fPWNcTvAbKp70QeYUUkUCxmQB/71K8qOk/IZlyFxzRihJ5/hUg8pI6KWZo5aWSVWU/ySFQYlQyENxJ7L5+F/jexFghxhbFLOTCpcKhjt0yyJkC7ox7PqxVxTk7dxqlVLlZTE0wVhcKgijdkyKX4W0j5vLlrmf63glZcr6mPfWnfsnFAA2pFGwqvZnGfbw67GUjzI9UhsSV27z3RZmqxjQLYPsfnXf1jSr0YYOwidJEUG8ZMkok8fGpK+gou9nFSoI8fX94qImt5oXfuWAatHrWUNEi1y9YYfPdwv58SNHCIq6aWL6VNNBeKMxWg7n2la66tfRlr3WHgrLjLjWBGOE+0dxVryLMwhXSNs9FoEpcj2VLM48jIjGCcaw03zsF5VL/ddEY=
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