je0U9VR4Fq6KGRC+5wQRlJEuKHvTjaVF7UDvw+aoYAS0XvNSnZIj/cYj6Zg+XiXA12AxYU7JpnLWIwzKJl8JZ8hYqN8bsdPi1uYv9AwdmNQBtKBIoDbTOiP4Tn5aV73RTxw741eXHOVyS+3JNoQ0mmh7kpxig+QjJl9AX8x7+ndg7plL2saXLWLrdvSrN2ZfZth2Y5X5cZOF1ju3yvBCm25dVJLm426Pol7lDkwKNr82Rie0uZOaNsWVxQLqi1NlOVUkuy/LQBY9bMBGrTLvXnFzo6QJtzY25aUCoSI162DXRf+He3u8dztjiS9KV8CkYzH6dTl6eDyucCWdNhaaZbrN14I7/d6SRnapD8A69qYQc8/Ps6njNMnQVtiAGnHqjd/Q+MzfuUo1d4zQhrLnS/TpsnR6BRqvrKOENgGz8uJGmuy6CIcDMfoZhkoDcBU1TpPa7EMmo9BPrt8hPddagouWTn/h5OQOTG/dzGTuQhCn2eF7ejo/cH21/Fv5Hov/e6jmoxfOQLF+QpWAXM2RwatjFMl9H1gzazWIbtgebYsvaoVpfsHNLCqzYn8LQLRvzFPdo5F96pglOUoVvF734cGf+WsWawZNBWMJpzraJLOb/ew8kdtUNicGGTf1vJ0yB6yNpLMuOHrZ1ep2deM79dg+PjSSPwDY2B9sEGVSjI/cXVItNzoRtgEs891D9BhhlOA2sxE/F0EoWJoKD5pr8/TyDYforPDc4HjX6PWypraBb6szRZTWfnI1ywodiuIW7rjCSzHHhilB4Juw7rjrgzp6JKjAipqSo/eqD67vEKGHSRdz1tKjfmLXkasJODsPUbIaDxqMR2ee3oPXuOpA9/8IAILiUmS4siXQrM5NjwBWLtJ0EUUfK/KnC2NEA/QhPikYd+/81UHB63uT1bQlNJBW4g1PtVfqMnGqFIHdxs26VoroChVeIDEzTXDK+5ECe+odefFzXCxhgEOsOXxu8ygFbrMs4lr+o/rRTpCCNGwY7ckwPCM3iOWXQoWCuyOCAojzDbjDO+17zfixPgagWEPAkSwNff90joGcNJPUaE7oJxNlJ4FzPaWpSOMEJBFk0mlEkbu0dYysI1xCqPU+LVO7Qb5QDZyfQ0UoSxuY0fAenXKF6BFe6KuOa5hRZc0QisU/GwNzLOIUC6VDZV9qcDzHCoOndyaKnfO1BzeFaRMBOWbBcuC4ZXqZWX+Wh9T+MoxyElETy6ipY3AEzYLtHGlzUtU/tkj0o3V5JpJpmWeQ8i2XcRY2nN7hrDTz+LULssptbxXldjEGdahcu0urOy/FTb1pf/0TLIJEAdDKOVRzUNZe0P0a/+9VOLHpw45/K4Xl0EqMv+/UOFw1U4VDmn0jKkjUc+7HJRHavug=
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