MWdcT/4ySG3DAHdORrASthU5M6lYT/MZpWbuKua6Akmw9/TS+Op/bMQg5iBbHtfNzlNw+4f6Kp/fYZgCLN+CSV/6/56+qjO/dfOPn7jmQjREZw7kUM2OJ3c6laVeykXn1+DzbNOVVUc+hDI/8JZ/17UOrX48C0fFlymgnALawFvFBDAmAfi+z8M0iSDetqG45BgPlTzReTXlEeqZlwO7Opnm0cIkul6QnukVhHZRuM3xzl6y2eLN38ouKBqp9H9VYZmdUuM3W3F6st14TY4NMbDH3fw8i7UayGg/ygHpU9kMpN7KUrnDd8fxmnLhztIZ+zFRQCEyTNpAVOjkFiQaLKDgOY+OFuhUZ1jvNfFtMbyJGrpM+1A2R6KMcYlKtu+xb0rXxHUwtTMF7hijsvMORRQWxdWCvuZwp7hP/4oFmiPy6qrjVJgZGTa6nq8p2lYAOjXRyRaUojR8S7rdmI7J3eTF/XV6OTpfS7FnpMDOO2HMB7DlRmP6ohSnWqiFdJCyplyoArwyaf2sNzxsZYuyu7JbS5TA4NwkExFEefT9bZrv+ZSjB99BjiwANJaXEi6u26yosrDGnfCH4gnjMDDAZkgwgymejmMPv3PjfG6AtwNgOZ9C/VQG7Rx/2HNYL0IzZ70Z3f1gjhSaFogRbEoVHicB98iJjYWvMnPFX8kwDht5MlqcfcTldr4uNDOklyARG53+4JME4LD5ThsVxvSfSYqZj+9OBj0cnX3tqrikMIcYdgcsVZC02fPYMLr64qlS8nO7NIp8g1i3HAB+PIS371pDpP8jKKl92S0ouxo7ta3F1VzE5dZP0bp1j/jakMvGPCREzkX7zyqYyIxJ9h4DyyC0Pg2yLUss8+iLXyAMo83GSn9eZLqmiTXCtnhPkIH1z1Hc91D+lix4Septpw8vF49hZeeMYCFOOSrFO3t+JxwXsYHxC9BnW9QLEaRC40TJlyN7Y/JE9qjB5BX/qAWu777qQBOH9gzbN/uI8iggBCyyeFU3NhbfqqS9RYZsa8okyG/9+Hg9mAfGzhELVFVbkM7mXCvfrwki2Vf+8LK1EuWRoHaDZcaCB3owcIUrOH3e/XCpA+9/ONoeyHzeCQcNvblsEZFhGITqN+2s+Huih+gQ4is/O7O7xhYO+o7E6qBpdNaB7tbW8fiEL8QF4n+VPkVxWVGhaCFvzWPj7pii9vQ6GtijUi68B4q4+jNSz04W7QHNfNu/YK1RdBnkEC4QTq7xlw7xrC1ZzPySJcW8eLQ2wV3sLoMDRVNu9FSI9OTt+7qsbnkBoFknALg0TMW5y+dYFot6Pi7rJnYmOQltb3h/yl5dnbGFaSiDFSQ78xZE5PDbbuYKI67dJVrR9L1ovQvMVw2Q5oDdc7cojF8=
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