2XuSdBz4ecK8R7V/6oYf2PvzXDZ3psYT9LZqGOBJIVLN28EW3wwN1UD2oBgz64cDkw7518Pn4aB4MYvczOLljGtvje/XJ2MJSyxaYm0Ee5F9A7pbw9x9B5g4R2S1kBkFHjKqniQPW+TYFGpB+UH6/ftcrJIK3x22il/l4s75XT7py5gD3sX5HcilDcMHy0XVW81tmAwBCVMW9yxKzZUWfiFY9tFXyYg2gSHkoACoq7ub5jdWns9YkX1+ILStj9Dc9Huh/7yyPEbi3F2IDeE1abhNstOf5E6mvhKCFHfeB2nYVdJ7p4HF7ifpbIV7rVUS5YSPx1E3qv32DnC6zFBanwOxXGUKTGnEvm63EwWWSy3sIdMMdAcGBxIjMfjNyjzmh5tSYk2z6BsN7ui9jRSqnDaMgUHA9OXw/B/f6zKD2hYdnayRyYwQkCLwOeCyVcHfexMtDpoKIOD2TGyOoKOsFPE5nZOGRNOaXuh4HKJ+nK+2hp/8zolDe9GdfDdFW4ohDRmGxnl7a6JxmgHwCBeF6W/B+PF/dL62fFLGrQhWyuNBIpYwMCuIE7mjeUGjJnm08q7iT7XZLc3wtgzKKOoHzrhX6Ac74qM8JXmrTm91uBtA2G2LLm0yze3mCEdg9VxlC8XtU9IdoT5R7zwbQ01FL5EqxIhWKoeipwBXW37owG/E87s3GIwUZMqIyGOQWSgqR58W3qBBS/Wm80ZkKgnVlm+I/5yyXeYM5hJPwgfuGIWxUwu+Tl3KHxuhR09GhYrr/wgHA/90ECy1xRK6rQgRC5QDFOrTxqCL4uKE04ccN5Hw2XSQABKDdvKqPZWHEV4KXBe8VlkgcGm+uLOYriU0SmEvwXD1uKJpTSbUlhD27aUFh9L24OBD1LG+Rekm6bjOy+aq8ESdS/H4zUWZKYkF8wx1cAgU+fxlWOmYcxxBlALtNwoRznaG+upIslVVbdPmChGPdEx6bR+tibHlUb0LMnfnYOdpZJ7IvAidwVkewYoKIZI0LhW16Gw54ikuL4TIZGS9ytvqq/76mvkp/iSybzK5uFnrXVSbFT7qrdAR2m8QJeoTtmmPLUzZuPitq7REIa7nyVoMi1OOhTIIHl2HnoYDhAKgWGL6tDJX6RpkoYzkm/rjImZXdMEvYafWAMgAxsMyBgHv6gHk4h06ufpxxUSQqxPGMSwnPDiIp38KIxTlFW/Vx2HDEqAYvhbtO4DBPgYe9O07kTGOg5mPVrcsUv4l8P9qbiwcG63rX27UHMwkg5sSF2TPVpWmRFRmyOFfUjrZuJhPL8kCBtyUHO2IAeTgh0NbNMuiwLT1LkOQ9Co6HByCqbVNfHvqIh5A9bGRJb2FT08ZV5X1m1kdqYNja588wINupXb3M6lt4S4=
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