doYjZBE5pH1DPQ1vKIM6nN9+0lNWDSvAspr4kfLIYU0ENPomLoLqF2ySne5TtjDZAnhQ5aycNXX/CfSHBtDyxqCdyWBocYPad3D3pugFE4Mu8xHfM4RVFkG90t7CrY1sDdGjBiN13JHkzLOmPCNYoEMZgb6F2fq4fRVeOtT1wFKIoAOdbzSV3gJlAyfMJluvRYTIj8rq40oTIeTadpQywT/5OjdmyJvTznH+rA/K8NL6Glj1wz+R86o2jr21Ig+EXEODQvlPdLjEFA4WY1cmT8VLSJB4EfknI61lI23/Sf9TVQ2L5tEkd/o9OB5xuupOlfqQ/8jCq3XgD3oOaDH3P78F8Y2FXSGJoay7EJK0oCTiUDG4/b0CLnKWmNS85wc6ELAtBw266MOHdI5Limp+1nsdCWslXD6TWTE0n3JCPOnCVCCxdXwvBF9ClYhCABfurL9Op1reNRfsZMBdhZ/1HsUTFzPZ80Zo5ZmaOy4WqB8YulY0oxE2d60UOYlVKsQQUoVtHPhaT7SkkpUIAI8MzJVapxLxGIvkqxV0T0LOIm9WqxgjhqzwuGnuQGS1hWfcE9N2mm9+/m517pWLeM3L+/Q2fGHsp//6+JrihwbGWVLCjg/RqrIHkDq48EV89bxerv6APl5cvtie5Dw4/klYcEhdxEqnXUoUEgHqDJW+wF0EJo7dHDD/eNqck26xb3m2hCq2HzCGNIlJlxj7hIfdkkKYBLQySQxC1k63PCIhf252jrUTH8jpWaXtwhq/Nqt36RA4Hmf+2HFaO1rnWQDc7hWtGMpKQtsWIZfldfLQ7DpyfzipApRyxCPZbxkRIHkBC3HwmJtVVHzuJLDW3htQTKqJM/eNVanLORhwLNrd4cprS4p3HFiyImcbAEAqwh3jZJATHyR9ZhrAKJFPbSwEVmINjuaoP8MY0MUVKmSWk8tYlQYxasFmEffX6xkH+Tx56cj511mB5DN3m4SR3g4AePy9vHtxUUyunOLyOGu4vPdYe9vb+wgbdkzn3KzCxaGVP8pVEaOnoAjMP5rMXV2ChJeV8XllmZLFhHMl4x2oUbF9UDGJGsZFKW71KacdjYttw11cryXfAfGb1enw6Gr1CDGQViiZjx/KnoOW/OXpOSnrNR970/FFbN/SsfWXmnIAkHlk+pORgyS/Kc9RldAMtC/x7RKlC1kPySrz9eRnh0q5yaZp1AiWkDXJSTUEATYwPUYfoIw1MeouM/r9ihJ1tg1mCB2ZhZrxFLiMyW4KUK0V/qYAEa5g85pKQsKKSd9cOOgb99I/Xmqo0s/ZrMz39qdCfHKcrd6XUBKai2sfBcPrESgIM32RNCciyZY7YXQH7A8he5g5+jw0wnS/S3sFmPhFQkgj5e/uOsUSfHc=
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