wGFMznsAGocLD2C7xJrvWoc784yRDZ6UTZmc0g0vWozT70QOhFnM6+rvUkWzrffQlBXUc0Lf0MDR7x/nWMX3ejMlZWT+1hZEQlMO+3nDecWCMiMNsrFZbcCMgjWN6dDNW/qTqok+DOXGRZV5a01O8483/yvdzdYzY3tR5y30oDS4Mc8aselucbhnVvDIjpytSaWn1BjtJ8vj0TQibHJ+uK5W5vmnAC6FsYHFZUfg45RG7EAXft+nQErytb9ykz8srGcerng0nOs+TdDAim/N8arlqeNgSBoXS/2DdrQJC8fWvA9d6DV+wlaZkxSud5wP/Fu64CGEQY1ZaIHSBuoaqifcrI2fyDh2Mwl5veGpjmin5Qolc1ydxkaV4gzQ20RkXqJkNHFD2wvOIYOr9zIwnYiLfod+UdJGWe0mBsRToT6quF8xH9uB9wm9Z/mqCpS226YP2EIj8cYVxk7HMXk2YPo7xg+6D0Y9UWBUESXXen8ft7GWQpPr0cila9yaIXumrZ3kWe53yLMG9swYNF8Aszmxnc7ucZ70eO3SJxWwi5oy7LNnQ18YPwiu/E6DkHSOpnLRAqoCLweqpRHJIm5+BPiwyqpLVHZzL5q8TRU2pd0Y2BnruRgorTfDLBPhKilR5BOXC5YpzxKo2kSsyqmmRS+gX2kQX2HYBVyFYXKndXavHiffXO04Qoj7bhThpFITkypXWyllzWtHze6uCzxzW2QPFiK2/Vzxrn6nb22tzeLVz3DFzOaQcq8M719xzbWiBOjqTqtr3X35S1nTVbMvztL6DLf99wqc+dmgo18tdw17tNeEijkDjmUVPkFq0sfaJHLACkclBuoboABhe7nvyALygTQ9H0Roqxmv90QQwC4sFvPzcBoXTMeZHqUP6pfiyTsPTOIw1a/fGmTgMPhqAd5FryaFkONO0eFfgPs0n6vEQkYo1Ye5tJRqXlSNmJqjc9Y8fvQjiFBa8BQkOP/uo6PGQMdai1OV9feA2M01Jt3y1oUtCFpIJEkUrZayo2YBI4LYj22IQUPLe+cKlL+Rhlnhmqz3Z+zfzXrzh3jtbszp52j3IgMq7HxUElJ5vEicEmQGJkdA69jy5/AEi+qaSfx7e8jJHygRdoA4rAksEx6mRDAmQCEEYFg3+H1cFsbKf1y0hUZJH8f6ADYX3xrDT1ep09DjbFEGvurR+MwHN5h4yeuocBJX2HX7/sauuX5VU5I34kWnPy2yB5tKKXu9XRW6sj1gSKrstsNMBI7CDXeCkOMAkR9wQjNwNLNUpZUqgGZfhS5eIB+Scc1aKjfyfTUqSPGfG2QfFrpdJnvsquDy3Uxpb0oKyqcq5+PpbDx1SJRBVBGAPoUcKeN/4mVYd77EM82ekv0XauX+fuo=
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