DvWjhF9qaR6BPUFPTi+ToqHKFeIiabL4YrHnwn3qtoJ/+aJRCKdV3o2NvAgr45KWzbFAC/1h5f5bfGMWfLGcadkvuYLGmu0NYmb2oOfL/8ZI+Btn6fTS7NGiBVEtv+1woFEUzUOMI2WHcLnSIZH/WrrRltbHQrj2Cdbaqc5DfIwfN8falH7qsfVteZmZtqSEn7eQA1WEkfN/gUvrmM60f3C2mIDDRVgzylLxukttXS0SLB8qT0f0itoN13ZpgfRuLUqk+TQG7TEEuLJZ684e+gaZMCI6j8SPkwPmcTwSQe90z/WK2Czp3CQY6jk/2mGpscw0qHDw9jQWuo6guDTM+Rg+JrFUgBuwHAzdsNtSjz6/1qn91NiM4hrVVqkDHRxjEI0zSGyvdr05TR5qKzngEOAye3mHvU5eVomBXURIYbh1g7Jty3T/qkB3rtvnMGq8PJpQFoht0X8tbTknrdmZRwgj6/sNwsBRsclUSkq+UW1vu8T8jQb7MZaiXn6Y3hnd9vVY8gj1WCaS1pKheWruCh89716WjvUL+lTcODOH1BSCXQQbMwYtrM6exbaKR94iRXey1Ckwc9+KS9M8cAcFR5OAXCICjKOQx+LiLEi6dxMIYRpSe3wuAAK4F3gy1IfLbEMDOoDwyNN7hCBJPgGfflmh1FKJBDNmmInMwxUpbzdknG/wlQv5s5oRdYUUR9x0egafhWomi9iXVYLJNjQW+Mgfnc44bUvj04dHpRdAB6r75eAVUKbIRL8Q7y2zpxl+8NpCMceo2em/+FR3Sz760DhbY/2KJnMqJ5n6MMlkrOwXZr6zkzte/SBhVaMhRlwbay13PDenr66vKmaNF51X7rNpI8aBLHjPhK46SU5avV2EIzP++Mmt++lgCpSjE3GiDRUMt5DcSImkE6cQ9Zk80oegw9ygMBBPa3pXxUzL4vB9Qypr6M7emBIkr+32rr5bdoZsfFBgV7zQrb97OoSvxRKGZRwQN2at11qwoVYWOLjgJXmmUPW+YJiXHX9cJpRBoLkSd7/ljegYjRuNPDoqA2+yDbtPho5oA1T0ileI+c3Wwz4bwMXaN8kVswMh+MdpsnlMZRc4Z6GcG8bquizb2I9U7PprAAUQvR2X5M6a34rngNsTC+TgpcXBQFgw9cstwIA07XwFh33Cx7j7womRDcc+HpRIPxuq/fE0if/grs4qApbBm95aZ4aRjIELz6FQ3gAbAAR+sZnllIDSjWFSLguQnPM4XIbAS7M4zZJ/kTBIL+FYJdHrcu8XhMpyHtZVSD+w2G3cnCuMJVCaNetHX7nbCh12BdKG5FOCyr+QSra90WYCZm6yGxRM/D1JQXIjFhj5nLEq++gzwaclI0A0H9XyxkMwbrPbdKpBPYQ=
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