Jc+ErvJQwrllb+2MHi1Kt/GeEFKnuIoCN/3PuOsXwvIUwwDBGNINvUys45PUVGfmMwYU/e1DYivhF/+4BPgg8K4rzRafTG6o9uFqgvkC97txWmWmy4CNkMzjZo0aKlVlRPyRKcybgHKIIsr5ijWUjhtFEdItC/Rxwph94/fdrpcgZWs2menUXcfoB7r+wI+xFW4xJ1uz95qveJPILDU2Y/qR36JMNmGYXRl6cgPXJmPdiAnO6sIr8YFKpz+/ehfa75K2mv4DuYtmg9Uf8wCjD2wD59LHW6aLEm1T/y2NMUcepBsOhHml/GUKgg/vaHpRKus2jpujR+Wj1HOPeb+D7CNro+itGtVDPsBjYDcS6I9Y1bPNgkiB/fOVkIiViB/Ar6jaH71iX23cBUB+SkM9YXXY4eApVbKKJWWpi597GmFjqrKlZAnxmoyGULJAQfqnrxRirHyWnMR9MDIOnkTMIuvywgPCdvW2fl/JIcN/Ma6KBNRtSMN1stfPotdQNuCp9nGra1yR9AAY7J3oQzzxb9RGNHxnmvWQ/xi4eewR0f3Ae5+8rcemyv95RS5/Xk5T/j8EIwFhXSiWNf8K64kxGu9SAhIMuOKWMWGiDlY2Q3StiEiE+VkG9CM6ylZHbaZC+3gXuLcKcX9DRE9j7Bc8P+Cub+K5CRB9DY5SEVe+UPjCftTS1v1Qoq17Cz11PvpY8wFuE7ax9lkhbiK+IcbGQo+2QZKt3Qu9pb7ZPdWCC1JTVva4wpa4broNu0Ol9xfomuBett1qcxPv7aYKAtBNMjpMVpf+GbPTuqdaf1omm0ipQMoSTCs5N/sjuxjwJ9BaCXrHyhdBuDHTBQwqabX+QcfZSse1yBbXcHESOBPfPwpbLcn2xAsdSW5HPh0qCve6emwqhBz4XuICPp9IxOfnrBvb8Ku0YtLk3M860KfAX35JE8ZBoBSV0N4uiXVll3Gx+B1ttjA68TGGINSjL5/u6l5T//7/bZXcVndSKGAK6nZIvaye9KpN3lEe1ZVwfuGvI6m5Sfg/g3CJJlAS4JqoMDN5EZWrShI1DbGBJ3/8Czn6EMKbBf1jd5dMIU2j/28t2W50kVIrnnruQq/EXYiJnIVnlfr8H3baPGgCh9zYPrFXJ7pzn+hSST/Df9QB0JL8iUO9UJFzgBvGREYxIUjcWf+5SkzrtNBEoOof3ph/HS/IAPxTfsDfMrrr00QTlCR6ybbSxZBdV110X3WxgSmObgS2jFEy+Ch2gqIz2zkMM7TNZYHNpPuMDD+WXuhUFYTEdlXB/YmRmB4oR5wfzjcrtehNG3qYw79MtiE7MEYRIuQskGWgSH0e0NwsyPPXZRXdkaKCgOq8bXkUPivfEVyMjHp0nMwv19u7yxDu/z8=
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