lxFCagxzsXVOG1ua2+cIRg+TrlE346XnGjsvQag9YIGmrKgo/bq8SowPGNKY+Z+iJHFBpXNYH95TxwaK6OFrH7XKGLFDYz2KwMDqgAF7MhkoaGLaJ4Xi2jPgr4G2vTWluC4tcD3W6+5ruOv0yIwjn6Ivok3F1fVRLqP381JD/RapFoJCICBLBtRm8MnYu+VdQ2AMPx20dKjOzBmQrZYAKk5i9aFYLlox5n/qoLqFWgbDwqWbPnGugAZWwVdRmbA+mfPy02N94olySYIdu6V60YZEWvFDVBRisvNPnxOAzXjE9+yF9qrcgaG5U711AWd2UfvFZe2TGGsz+IuRSw2BMIVIJCGilf+9lTCCQ6OGULNDLy6LYuiU9ifevdABHfddwYw1Pw5448rwtuXukdS1LMYuQFSDJx+C0N4yUwj7oxUgN+kabbqQ8KUyhlwf9rmwjl7kbCWhKe9V8Ieqlv6jgbAsaV3IfxJQZF4vbAfOyd0o6IARLUlm74YlXESA86GpXedIUAUix3XLQqgdKFCv/oPwPf08TaSYtEPE/kDXUXm14paUiYNiYNDy8kEFjBGaDhWoLs+bH6qTD/hSxeGAe/WvQWT4EM2tO/WtvSmRoNrmVdX6PgJ1VL/q8e0jzR9GzVGg0U10yKkt4DoxyI2whm98fyeise71u7yZTlp/biLwuKnwMptKTj2dJIZVQQ5+ReN4WJoBL6AODqDKGzP1tmrbWc3yEizw3I9jxIkvCksiBce4cmKjxlb4MoymAsPJKizbZ8BR3Dq0AcWDMe/MXqwPL7hCyLTfo2d2b0ZSLJwxMHwocfao7+zcUk2S2V2FvB1c89S6ko/FtDXCErfts06H2kcjIpiv5s/PfyjLsVbTgGHUN+uQiCGP+s+Woj8IIrAjtlFhyjScV9oDqSjyRG7lpYI7kCMjMBF4nH9EQzS6B2+E34Yf9hGi35ULERcxBtqPN/KbH/szp6zowEwyd6blHfR3+b0V39mAjFQglxWFhYG67w/teyaAhPY2K692JvAaLZymxBcvrus/2HQi4kkcWuiqY5sgFkjNGVFOaO2kN4Xdna2pA6P15vGIq4dQ2k4vZ710nKPoKUKtxH3rwNjlMgM5cLdHyhPIpUj6dLLSWoswT+cdnfAeMwvDqnWXWIAhBzTg9bIDIRWyZtj44ahBjaR4joBZS1ITgJMP4akJrCYBByPWHfOjlldti+q5sgqkz4fS8i46Qb3y9jagLOAh/4Wi4TYbx56ffmQ5unUD14waqPh0jkzbXGmbftA6rlK7UCA5GIgqwyqeOFY3A8gBQdiHrVrotNebh5wU+Pn0rJ11cU7zpZEx1coNG3d0aIZqWPjDlgzM1GdkVrsP7zyjHVZZZZvgNoXng4g=
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