PMnKXgyg9YdSAsuqRfAQvHYE/iAV2iR8fAACEHBSAivyuXvl/5U1uM/MU7wWIL9fQ/VLvJBzsI0y9D6FZlO3S7IxCeVr9967eSNugeHoOtpq6N0+x5qMzxFb/oRH6wND61OG2IoXB+5kO1536sS7re7CmrjRrF0DVz/+50zq3MtRU+dCjTZej4gdQ9Xe3pKg38Y2l/J8w/NtPpF0J662kxRd6iWFzjvHIjDGZ97lYmLHkcNQ8bqq3c3pFILRiYFrPs6/qMQNgg4h+OexsobvmBQET6EAJQK0IVrbRN9reldLHH2yP4RuxKDWt/6sbgnzMKVQ6DdFmLmgoihNZFap86k3kv8M63uiPEHl6c5oFOnyNKhmzlPpAI3ju9v9xXDqJ7HqBWVv/zDCVEOuPkfjhp4N1Ivaxguq/GVi8G8Kam2I3IZGx/2V68nL8dUAo/SjEa03Mz/H9GO1JH8o31lZpFU3dje9y6jmyFQNFK43GeMuq1udXCPb65PpX3TBuX+hOq6T20pwFC40bH94/aAxV+NcSqGr3L5x9eZV9TV2JPfJ68w/Iw1Rg02+jY5nhtVL3m/6gRwP1x9Zj0yTnwHDNKNFce1dQy9+0sW/QSjdx+4N5PqN3I8EtDb2GXLaCfjDiDVnJovtmC1OhCrS8K1epYcPyI3CxSyFblAjqunzcXzdlSQ0C9Q2JF9WguG5N9Ba69FopLP+qvgpgzhiSfeeFFG/8R17mgWuAUdc91f98bBq4hurnx+uumXNjx+VDG3Qa8KJpeynHXNYE/lqHU89UtgtGTIaUyLjbRspyyXTKrqZafhyJ9ZabElsX14j6fatPRpuQutDENd+uSFPKN9iF2/6c5kXcJt2r3qPAI4uBMavwDTxVB7BNg/o9NPMsfKbymM1zmsb9wOXsYIxQhWG/r7QUAK3ZqBcK1u5J9URpaK1eyGXH/yksCpfhX70HKOmNYRr5kgmdGEmBtHGFVWYlTzpNDnamXDe1338/8A35lSk6R2acwCurwFIVRFyXtk7J98VyH/wjwmnef2TcoDWCS2tFbpa3hFaRzGtDjEOc1IlhxrTEvMJRLPOglurNKYzrLE+WfE7ru4jBJg3HlYVT9R5EXSLecDfz8hrvfKm/dXbzPEUHwaJv38l9oYLLMhAge1rK9lGYJBYb+BhtLp2aqZ8ejAXbyyDAljhXvqNH15g5VgiVoDABgokXin28Pn/vx+qrCe78VJoTCSh0lO10Q/lSCc1ZzeaCv7akLz2AcLg7siA97kYp5QEaDSOkN/wuZNThaxAl3l/Iw7MTfQzvmXtmoxxBSuRE8awDXU4eSCDUJrAhuf6uK1npm1Vyw59prbbgSEK3XVPG9dVvtcWPBlLRIy+jqI+WVp6FWI=
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