b3gu7NTE+Vxdu/46cKFYHP0tI1kZJfNhlwuCr5TTQgjbZLXrMJQGWlDH7oniNPouAHCmfW7+UjWN8LVgXS2yaoAa6A4KtKAEO6zC9ADPtYYimjWmYqCCahf/7NvfE6hnFots4LtNsIGJe3UqrLsk43h5BiV4VTBU7+KZu0Ky4I5/CnEpHfxz9Z514MNyVFUZ1m0XqhfICIJ3Y8MW7DH54xhIYPUZrUAOc7wtqj3hK2EdFE341XYDot4FEM9vukO8UXbcI83GiSCZgV14rBZnRgrEwUHyugM9zeARJ2KXzceu6oOJcxP99O+mEb5fs5DfVciHXaeQLJ8Eky4QitAvcqS1u3VOOpTePcQVzqMqVWGzaxnHOGuKhAE/r2Llfw/Wn7DAXhI/bJAUJNmBPS3CeFQ3Tto0O3OjSzVdYwlW8NdMCI+wxh2e4vFe/nKb5/MkJiaPBoTv0yr2EFjFTtvJpn/rVMIFqmdwnhUTzKbpCRlWoX35sLqsUkTce7CM5M6W1yqqBC2iSnBHmb82ONijzd+PFoyeuhFrPDAHtSXXl3eIzyvwgfrchCxSWdu4PwZA3EoP+xmXyD7xXLx1czqUIvnhPbYUg+e+tSY2FPdtuPzaLkfZxYqDt6ynZ0152owKnCH2GUcfdBGF74dKhs6ora4shHp6BZR7exF4PWrpVnIDMkd4XBZU1lnUxcEfPOQQBN/H3A1JlOJ2Gp28PJXiPjUNtNtEtW5wOFmoH8i/XVAdotvP1yvxXoqN9WgWq9td976rc50Y2F6TEK0ntp/CAjzMMkcuGblCrnx1rAbN01yAh85MGrOiLEHjxfTNIE0PiYExPo5vrHDUvxX5Y6yb2B2sDx5tlI7etyIYTHvdaDQ1DMAzI7Buht+8tdMP/iF8BIW0ipr5YjR0vLzfTR88p/hnNLhbPlW6Sq+umCMwN0YG1NExUzGaFaJXAeoXIW8YWgLtH0WVsmiX4sUFQtOXpq6+G/mUzkz7obmU0fmjF1NO0cOTI8cLpriJ84SdUCTdrkTV1CD2M89IY4mqEHh4SLh5dPTsOXswILIeHPpRvzE17xuq81avVJsFeyZrYfyg0d4KhD2T47QtZOD88SBjwEZ8MR/1duqb/m91qxDIJ7+aNy7ZeYhMdaR/5UmQPFjn8qK8N2PcaqVnLVs9vs8dZg4hIxMb6v9zb1dg/oz8/RRoA/tWzlElKZfWJKCdTTW3CY2gHBD81ZVD0pRX2yTeNLyTSiHgmazObKT3zrpUEmQHzenXh5ZFIdT+T83FuJbOgx45YP9vE0l8LXX29yVQ36BI/J3e6KWPghXeGWDoSKdFOWOB+NA/lfgSqBbKYyoGfdcpo25yzV85lkws0/5PqNGHOlVGskgZ/CUoFY4=
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