DggyGPq8sTnWHTbJsZOrPwh7YSgBj6Y9Gvj3FB8HWTFl/E6llR1vTo42z53U9ivDLB+DGwghitUroQnfticqvb5Anj+S1uOpDt8q49swntWJs9HgII6eKRPWvmruRRAy1qiX7sM73Yqz2LP0C/VFTjeebeqzUiZSqXeUOhE7mrznAVECNbIP7qryW4cFUo8E/X+Rl/IRneJKsQspDBWjyjx5EzkGwXfh4CdLBK8ldIlRtqsAG4DD3Iz/WXZqykl9Uo+utLkLu+qFS9GuuTIWrbSkF340pgl3IXpYfI3Xiu8H6/vHy2t8QqZTw4h+XXJkHlzlB0LbjKoOAvbQk4Wkkf/zMMXYhlW0lS/QN3GlJWE4WGXDqNNCoYp7yJs58MyMPjJaRlYvx0NIQQIRI1w6RwDPX/IMlUW4p/q8JFxAFKdFFNYGTMUachcN3Qj/ZfKbPhqJfct62/jF5/cA9dIXwBFtEGhC4ZchpXflYggdN4rm5s0gNvZ01FoHHPgfsINaE0esR7m3bCcj8sGY9G/bhn4VREh3Pzu8DoBYjyJxY1fees9wvy99g/Bi0QRHz/nj2grqk1/XVk7gfMGiXq03HLIYwYjVhQGFyn7ENKwsrAXebiv95ew+6t2i8whLOiUuNC8q9ai6xaCDdZ2lSY4eG6iQyT8fGsIQnC7PrvUJYZJIX9cmkHvhe5Bn4nKZs1QZSNWB820JSwtfbGcs4eWT9WL5Wih8UMRQ6zuF0yDYxZwuIZoDGQzd+PDZKOh+uDdb52JrhxZudDQF7rbDMz3MljeaDYX++tsVe4Njr0Lsy382XbWwkOpUAgmoWB9hDOu3etxb41ZrgqAt6bRzKcw8BaZxYZ3YdrCbNOURB7VSvAc716xhkySql9g4cHdcYQsScism11HZwDqzu6hQ4ATKsTyM1eaoaL7J9Kxi9hSJDV2N1dy9ZmUjFd7s+zcPnUAeyc5C/pcWuAxfyNw5OPBylHNEQLJ8x/Je0Wp7C6dP3Csxmj0SgB12nKqkaeV5qvs7RDt2BzGvseodD65Ng6Wd4Q2LGb8LV2b0yAcLfpX6zp62GgCWdBY9bvx8kmnOjgfkBIG/ZK6nDz9sNgl02vCxMTII+DMOZszgfTOWH8DQENbmIiwxycdS6IiHQWRV3jQ6XEH4w0wf+7DyHnjOsLeCAEgqj8QpoKBWbFm5nQ8Yq0S7923lP/BmCpASBuHv1sf07m518MtMG9CRlkN3brzDFj4QiriJhvwfSZ81vrdk7cpYXvkJdb1jPv+3SWHBaZxlyV21xLA0TpOsQrPNmlb6f644Ois36oPpxzPtY5sYnNxGoGmX1gsaKxmnd3980taHWxGzQLBM3BzZrqNPlLy55orz6Qwj3YN9Dfz4OpzyBSar0yYlxlHXb5hzpWESD/WWUhyOXoofCwL8zT/kM15UnXw1kazaER+K4mSiFYfBiuuQbZCzhD0ZzDsu5VO0jnLkm1/o6B8paTCb5p8qQKv8TJi+zuKI7lU83Xpf3iendKf9ls3y0EqH+f+05k7B2bqyLNweZzv/ZPK515FDOo09BKAjuTK8ONZK2UsLL3q6quUhAjtnSUu+8uvAJ/ltqPkRYaBosoE/GyV2+Xxtb0HEgwD6Psxw8f1jtFXgIRX3kOxQx2P5x11gt1gisBFVr83+M2zKZSbLF+Jbj9YUH+wGwE35gebO9TjTbBEB/FHk+GHpKbKkKoWWON4GILQ=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100