WP9N1y01agRSJ7mpdwCKa3aUN1l1V+fkGsAw6v+ArTE/qVMWC58oSBxqGaeAO/X9mrZulDAsJSw5gWNpIjx5dZqHQN6RPFtOtB/Z/MiBwe8xoMTiFJ7gKEpKEb5yI75lo9AOdjuJne18apjPh0GpSSA1X4xv1jhyvfy+zEArLQHqW6FcSwSMbce/f8CyTJEGIl1kSGFDXnSJRGbPhP3dmEEvkd43LPqXY44u9TLz+6fKuaSJmyI0dM7JHR+ofto//pk0hKpOsl8YloRwPoqHW9przKkNYeiOMrtDOZC90Hsi3KPrjb7+sQDPPSNbJuGArqfGDF2f8SwSKD2e9bwCELn7XwH2uB0FE7mdW9YPnuq16aN3+WRemEvMSNfXdmoeUB7ha3K1pZRm2H+4Tp3MwimJRv2ZtNQCG7oo2srBLCVo7xipE0LqBaSxigrDCoDTQToEwyulC16OLuhR2YPVDxXtOlNhf5KTkq0ESxRhA8vcovyjrL82gBa+1QpoKjDQhHxUh/f6oIcg8fQZxsWUCe61AneVYnKd3g6A7slrGJ6vG/Cf2lcG16zFptMThQt/9nAnJafmaTLNalSJZEQ2IlE0JATDGuS2jK3haP3kIqp+g6AS3+64JutCaGD53yd6TsfZ8asB4uiZgWfW1n61Ij83vW7KLlMthbmyGfHeyW0PyAcGG0O/AzczT1SWDSvvkleSnpr0kg2zAt16H9AGZwke+m50mtIE7r2xI0BmU09t/P72tc7sHcCNv/BRWCOjFIlTHjwEGMGwg8fBZDwwUxm8RYS83UuNbR3++o4dXmdJTpa/HB/4o86UA5U0dzq+CoLwCbck32z/rYAnFn4Qcygo3bc8EVHcv5cUNRGiBRfcN65wMXENUam1ZTJ8n1ESlyCoa8RjJhmP1jMTyCVg0gU/bd3SXY7FvsRGdl8qGWzWmf+E85tleDgYfyaorjkgA8gA/GyKxPclFpN6/8986DDMrfB2pwUIsKD/qBpGIMR+syyGM9F2LpX9FGN3JC2M9elTQfccFpUYUYgCkibP4zorgOal6ErYb2irOBi8m1F/XUzYx1res0wZTz+WLsWanKtPswxqE9alzwVPuwnb/BJ2lXjg2YgeG1VLHnkR5S0r1jlRR9w45nHoaPnqf1CYHOY1ehPWiMA0PLWaKClbZxQpAavpqFrMzTftruypSl/Vfr3B9LpB7ioOsf5HAuYeY3J87qyuUx4KEm1YJaW3UyMcS6eVt4NAyXPMyXCfFuTr0mTqhPNLyzk+gR6AYCklOb7L88ed4OyXwcDaNh0MXTT59i18r8HbW8gUU/cw7LASPOAmOHSAwrDRdf+WGZbL/oBcMA+fRzLicxKceVbW/3gsS5gPGhqd6q8wpY8=
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