RBiiIBQxxuEhyJC8gHAwM40/3epSItPQldcT4bPL/wyHx03HF8pR9aPxf6eGEuI9Dac2ceV2z4bie8DYeLUyIHtly6XDtFECAfYdMzAxZ0R4DhL5TZ7ar0lMSIshH4zGaflHlPd5FIG6FcWdCTRI8Rzwt9QIK637hcS9yllnXAkc74QRQbqjhEU1lpYm+zmkbPWU91PtcXJKld4lTynSSRbeTzI5SHhTHmU/X3AXxNg/6VC9x8FoW2Xep8Nf1l8lgfGML480QGlW2TDlVfrVB99zVR3PKR6ZT8p3FcnMNOQ2jRPsYzcZx6MHCUP/DrXZm9Q9QpsNGSXeyy1Z/TOJ6MVqy1CtJ0TxvBhNwZli7B+oWlgXgGIfJnOm3tSBB1qqv0SeZB0bGtEqjAi1uYvNkOVnm1BtlBO7BfEYz/l72YnM4ILYcaubzfH0YWhguf7Mk9njml5zLbu44nL3TDylLFT8Nq6INH5DK+kpdRWjeH3p12Uq/fn08STRGV9QGfri2fPd2FzTyZLeZzlbWgZNVo9orHwXDLDZc9HmkAh3JFWDfNhB6KCpwYURrAp1MktbNxvMCyb2opmxu+eXCq5fD5xHVKd+6nepLDNL0oZEu7u23hFO82Mrt00Pj9xgKj2YDlpGpWCYCgE4SlMFHJGUTLyJuQhRP8EpK6F0vCA7oaP8EtzGLaDKsFbnm7U9/+04pE4L8btDLsKBrid+lZaYCUgTFzA0mkBc37VH2N8PvPruo96GgPembikir0FBbc1myTuLqlvfxqqSfRsyfcbjSyCqpU/BwbB+se6adKKcPt7hUYuezzDbjJMUUDc47EGV6L79P1nV2+MIZie5CK4fhCow8VjSD82SkBXUHsg7/ivB8aP/PfbnyNEyX3rK/XJhHMk1YhHNj6teYc3G7HI8N4LMbQ5xuE43Gto8cZJkD+DWZYGWzOStoHvgyUV3KvKMJo35dEcvyiCaLSvHK02hIf43mHRzJ2YqIXGTWMUgRsyMRs7T2pTzW59uciXZdfIsfoLsn81UL/ntKsR7v+ZPxCDoiXliTSRooutYw6ByGDR0VM81UvffH8iDKdwxgJosWMNTeAUkiHIcVw6eWoC/VKj0gQVHNnGBcmBKce9N+MG4nyVyKV80kXs3ekVpn04dpQ/psx2sJxgm1hzK7cUrTuJTfxS3iBdS2GncSaCUq7MLDaFoncHE2wBxnB7MwiJwBNAsBAoxoITwynZEBglQTM3WRaaqmKOJ8PTx7Yx3Mxci51Ss9rKOxBds71+IKTQ50ehvFo+N41jkdYlkOAmoYIYIC70JKynqgbmngRIFHh9kFA+J0Y1zYs4Dibiul98rAhiYjgfSYuee9lV954muNNP0vLjHneY8gLGlAXE=
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