mVTs/q4uamqUt1S7saoP3RJ5DXmvu7mdfsrjDHWZDg+i3qZ9wqvfsDs4uF68grqImYSRkUiRIUc0J5oVMhLtowX9+siluXBhLLFpH79FzJ0yxt+Oo9qcZtzVUAgDvtGi60GMgix/NBGr/CYwseBChiY1R9WOf8MD05vxFjhRk3JoBoZDdF9uf0mLeC7O/LPbrzDcnfT6hX4YI+ZAHjfrbNSmrTNBf8D4010H448kwEYfuEs1D1Z6OGlT3nvnFVbL6NjePyitqocNKdgFDPcbPUb1azM+FwqR6oIQUVpEvmMavTOc9qN7XTIeU9t0TyC61wGXFB7Ixx9rN18OeaNjSMYpLU6Oa5ZZhfAKfS1ENAbwACVkHRBsNqcvJGtdsZyH+bpcCn5h4urWFpxvFKxbU7/FAbJNcxaEpnRhBtWzmcGwFZU5nldL750AZuN7N8OB+qOxD/l7eETnKTtp0ku4cGcbsYaAoATX381JidH2JVBQdd4NHq80V3cT2VzsM2QPTY5tyPUeKgZs7FSxGGDESdLmm/qpbn0CcUFa4+zKGS59UKZr7+aH2CLF1z7/sYIH1E9gAVp1NkjfPD4kZ0EBbLsgKK6x8zmJODfgDfmAacFaQ+WF3Ct6gKv0GF1zpqmEvqVi91uqwUa2ahlHmFUm3O6pJAs0p3gbIOjkBo4uxzYN/HP1sBoDS0u3hvOjYDbhoyVLlDkqrVkdJDmLtkFhu6aho1WgihvElyW9h5NxhfTEANjCzvAVBmLgNQx2wx4kd/GvK8QYbQYG9dkDPAkJNKGYHEZW2yyCTpECA9tU37JLH6vkK2/kK4khPcIMeE5tbc0vj1qX74lbv9bSQJ6jw/TUzcBqgswWLi2eqtcWSazgqxV/9FIhc7ZTmf9NjmOIYeDZjNAnhnwKSBt7lUOw8BLTykvU00ACA/+Y3NQWQiJBGumXeuOmhowGkTKkFBUIz5e5lg0qLt1pNFZ5zCqvtUnkA4Ci8Oiv5w7qfGxchumCC7CBheGgwNuq+wrR+jKbTE0QZGXjZPYKNWV+4jvvQiCwwtLq8uvhrLUQa7Ar8wol4bH5DcEZVekf+vmTkLgCK9wkolHbbrBd+bmrUyh7gOV1ES252HmxQmmarfmQa0BjjfopWUvvLriGL+pgi87k4L654aeO/bDwpF3cKuM4k+/9aqg0pKqp/Z4SHHV+15nXbDBffe7TKf/Ty+qydDb4R8z92UgxCjuZSoRCyNLhOfrEuyexd9KJq6x0VbINBdCZp8R0dolCtg1IYLLyQPIekkI8XoRDgiFpg3PCQ5vKNdtETOwJYWYeJbgql83Xisa97DywdiwjVlostUMagwzAsi1bVz+BC1dVAwicXoFKKtNBOfIJ367zvsWU9FI=
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