YgBJZ87jR652EBwaMHVwxLpTjHcj2w8O1rNTFdlHp5YAEXCnEIL3unHvU553OpNIWnwwOPD5hImkwYKfKYJp3pk78b0l0y6CzywKqQIseGs7g1lBZ7nTOLH7a1Rykv7zRC+pqUSOYkShpaCZuEwKTTg3h5pCAGb9urs1Zq3VWf6qGTZC5vGIsfKECa06BaJPrl39J7th0wf5bUYELXKExEMdSiGnVAzqLVj0f9VvuTMGi6n73kyBiHAPliCmk1PRzPNnk9r1LOytB1zRPWyU1bx8Tfs2dcmR+W4A+pirsFtRSiyrHp9smOBtV8JeYNBtPo0gw4vCGJ7MfaCSajAYAWzCcFQb/SVZ8Utz2XqcQCSfJzx1N8x3rClWXbqgcS9iQkSIut8sAqTYgUoFGLGHX++RxFA1abivsu+rTXUlT3OnEy4rUCo2NXVVvgNfgiJmX41XGXZ4ZTpY63Jafe73+HwyNf5OZ5pVCs+fl3hmOi2moBbaUZkIXLOEueekVrYoGm/VT5+jX/uXYsqKGbEatsdWWw/WUGse+OFpZJplx+0azJgVfkQIpSYK3ja4wk9VzaRwUlbA5T8DMzYahDXE+6JCeXmgAQGV3D6RzbQZXIjUqITh0yN1wnu+XOLlS7ARmP+9eiW6AZLScOaKbN2FBLSeDunjTy6rf2/XRvNI1kPpk4xeyDRSxYN47PrGgw57FkjQyHgPAGM+eosGDHLV8/GIPC30GdrmlsfppQJ7Qbs7n1Gkdd15RpBJhKw5lQaguQgC4bsr5G4d+CfEPJLWwC6kXD2Ga4rKBgRQOgCOWnrGacp+PeYdF8WnCldkFvH0VnmohsGaZt61asGr1qrmJBwPdXGKqnGeLU+tfwnrSGVD6FVXAllpcZ4Ffpcqy4U0OciBL8mBb5U0HAodotquCFEfUpdE99uypqgdcHNrVOmjFCoPai69toE8s8O09WDwqcyOpW4zmezmWO0pREGH5C0pqm9hbD7jSo8YLBMPrsrvWz6YKbkoxPQuRhoejGh6+eYL1hm/XhoA1nHtoW/TDWeE8q/iGZUmyCLSNSqS7kPeqfPwrfE88xG4Nkc7kmLu5zDbmjLaJDfLt/AWmNOSnorntne48nl/6etCDM+QWTSxUoc4x1NPFWGaugQ8rvFPU7+xFBtjFEyjoFb3twz3o5uePtKCR9kxoFhqatCBBX709WrkZoYvFqrWrPgH223cW6a+nMzaI8HvmB4HT5SJ/s+dkakucJQCr9ziGB6MC71RjIKY/ABAm+ASN1x8wVqF/zW29+lYeMHnYKvIjDixyhrgmiA4XurvZomxmuIn0lvFjSViFN0ikAiXvbWwU2Z4t4JeGzPH56eJcuG0EHlqrjueJXNcKWWlxU2ZuNA=
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