Xwy1oo64sbMPyyZlS2hLhNvq8WkhmygfArtzL3z++7m0JUdeUDFun9C7c85nLjjO+MpnxK4F4QJ+9Hj09wmzh77wSOtTsa2PDYdynAf4VX33BXAEVa352/9TELsnEAMUdBzF0LmCxxfoe+PPXpdRhPie9Klp8tL+6KMcmOdoXRB3K08DLap9Sl1w/gVuYX3SVXD25KwISFUIgVDtfDZtU31liaQn846PKuN92djqBG9q0M81Em116m5svjZzW5ByKBFxpsLdx13/cX7UBI5987I4c15yIStR7DMy8Nz/4TpWVU8rBzU2l578ak2JRhCed84CotJQ/6RGFo4XPcYRE/mUGMYXtuOiWZeJbUuSMM9KLWrs8zs2OJcw1Ckl7N/36GLfkM5pKMIR5la94N1hKjfau3rs51Z70X6gVIh2JjX00fvA+co66o/gb6fzYAbDWLOZvPgtfLqynbu60zTczFI4q2tOhHqhRMV1RcACyTvIlgRPb5yWsu/iHxa0QSX+n1w6fWpQbYjUm7utNsOPgRDNM83La7hCQJ8qBicWTF8ltAphrkl7xsX6NNFTgb/Ob/7JJSwEjz99q9JaaeAvZBiOp05Pt1QKuy/cAjeZJ+7kJHu9HJB7Hl+psQp5w1sGuLyE7lbSPzKLZt9QAzMI5BGcRe5z4dVaDJlL+9y9acr7Ilgg12puXG0dW/88ZqS0P3ba6QRSCGuFoq/ZDbZpFxbSAcSyFaDCdb71t3dth4J/KEEK2av2OT7/DPulJgxNPWMArJXJ3FDtyU3rLn4YpSfWP9M0Ox05pyIW1Dg8sd6onWqR4nJCuK1yKP9NDBk+Wtwa3NBg+SsoEFypp6bG1YQTN/PByrG36fYXlwSOlagu643Raqwmi66mf716q9y43TvFXDIJGL6fG+yXzqBTKdbKchC4Tb/2Yp7PLDpImYmlSrFjReUZvexIN1i7hnJ3+MGv14TtGSHjMYmlrFBYj2yMPRN6XYYxjhh/vYxce2IJGRBBULkTpguIt4vqQwikrTVdP/SrBqAwhpHhB1gDZfWhfzxugMRzJwb9+VUN77oWKyB05wCmrqcECqeAo7hDVRTWQNPvV9JbIOuy/miOXvE7zILfOlUixWF9uUTTHHj15r/3/eYqLhGhjJv3PErKVktYgIXY0UrYVKBRwfXcV/ZoMklfviXimkFAPY2dCfLfjB7uGKF9TTmfm4gwcONysPs/FhLKztW45ZTx57MBZY2h+RlPo/CCt6iuJaEB/wCBt9y2i+rZgCXPCQE4XxCpZ9ZWHRissPqa/DBh9fIaM3cJBVjJ7V+DEs/swV+WWJG8rI453fD3er2INxCQD2z1Gp4LbXyP0cLvQkE/Eei/f3LGdw9VTT7eXEDMKJk=
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