v27Tr81ZjkslTZUcv5WNv8Rb+F/LJk2Ez5h+r3aLWrY98OnOx8VF/2UmN2MJBQMFYeJ89wMo/cDpBy0ioIZZ9IJjxmPjWMGNYygSUOuc3ouCsAMa9U5sA1j86rWBd9RWKaZK7237KjZbrBfzh9Uky8i0DrHgAt/dDR+SyYLVecppBRSnV8jC0iuuYjMzwxp/7/o/AduBaQ6o94V+QzCAmi4X9ZTk3eIQVICjo1RrpGF4gMjzVDjdWi0x7HcIVqTgHvVDOAp9Lctqnbeq3IkFej/IeYr4VDpJl9xh61eT4trZj04+njvbeB8fFLw0V4KGH6nzG4b8sMzGX5sKgodKh7ibXB27hvhyt/qCwNj2O1sxe1c+/vr5pjaCgzLLKzLY66aBMn6VCPhNkrHY2v31fsx9RrCZH7I4dFQbvq/JAs+YwT1dHS8E3BqU97Ncxj6ICNYK8BJch34cNz3pYvGWjgwo3ZUjB3QpKQ7HBWX80OBoYDXIGQaxcuNxX+DTz8D5piK4MeD3PwpYROdfsTiNbMdPtkOGboAHMppUVZYTVCNGIoGYbvLcXqYRE0tK7S+XaeiyRBrr41hQKujt0+DqOlc2nHqB1e5/pv+MCGTdXtVnkg/TN0WgaT2lqPNxIalNfb8jrE01oG22peEK9xKSJ3T0buGOnU7GM3eywMB1eiRwwdwywNSD6h+2IXULFQFUkqh5LJ0ulZXwQ+1MifuCiGYoQP4+xxYjBaA54It1qR55tN6DUM7e0XVfM0kMSPIYnjDlQcaMXXctMCrZroEQTeCqru48smuvgEH+8eRc1ce/6ZXF68ypTDG6Ydsl7VgnB9MOhFjA4sqVzOkatHoRvENTfz0Bi8wNn98efot1UnbFaKFyvArkMX8dyuQjGk9LAbGN5KBHG8Rd7FMdRn7AlrT1xql0MMEcTx+0OgAjlUr5vA123nuXysSHnnlueCfxu4V+FHyxcACqwF6qGddC+hRrRoOZAv4M6wsdh7yQ860OkJnH3aj4hI4Z5eGmQx4AuGOdgBPmph9ADxM/enLpIozhm6kHA2b2Tbc9SPvh31rGke7wW4RyLXPuZW+Q+5/78U8LNMJP7qT0Kv6jknc7/dYIWHQRwoxek2aCmE6dMhWDfDsagujI8P/OIZyyRUXvP0DE/NWDNj+Ec+C2gsORiK7hu4x6JppNZdqrig0ogOcD/4IG+FNfByrHMg1C1z/cvJPGrGFsJL4zBoqE2IckUKDcp5Q6X0tO0t/MSKO7mVimTUszVkpUVuXEFQBNw+7Hp841CYJlRLaT/KvH7IqeHI6PE0F3OWDto/X7n03dWu6dkiOMAlHfN13QnefdMk+N00kPU3CMDWI82SVKDPppgwdcuEb+WscuovBHhgY=
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