Mniz0ipHkNor+LPCCSQdfp9ddYveZL/GabPGre0DJZjjQRcsdio0CDlCh8aCMsi2Jcxo91BZcJKywTP62VOfuAas7OkKleB8oCcRCG+h5H7AXa24BMUi+FSIXNgf+QpmKWpwrzwSw51uCQ0KBBh3SToLlMDd7WzluDw9kpvvev4EZbhfq6kEQqUHNW22JYt9eeZA5OaGBZKVzGKl4lEfHaqGvYlSABBpwol8/jlyNB/X7MOybfC8fgZMnE/GTTqc0FXyuY5w55VKG+mIPLVKs+gRTdxQQsAtwpn2YAuKuBiKxdtYb8et6iEX3EsiKjI7VZDaNwy9cc1wT1Q5E3yw+WvKXu2cfHSxttjRS86rP4UnVQgErXmkk0+9SdhKY/Gf8M557mQP/y3fF2AM2rktX7B53aWQfmJkVCKuXnkSyLvPMyuTaG+uGCi8lKSQyyaZtYgYRg49jMvhKAyQfDT051RWwS0IdhJeTzqnFdQ01DmDBKpnOGPAOX0PhvaoTGLVaXASOVcScvEb/+oUYdD1WWYdkXfedfP3p8OJ4lPYU4LYCt2PnmcmZLBe6eLBAKLn6GYSnavYIBABpJnDsQr1YpAmfKeWP6qGbgIEVi4FI6wEzUw8NKpt2RLg4lD0IDAWPSMU1TPkgIb34ma9AG+fS6J1ZakqP7FGi2Efndk9bqQPAoWTSucIgQCXPakRber8Kt4wMXsW7VZOLjvTDSgjoNLb/2EYUvilgo9Ll6gwLCVoGcBsJcFVneZP+KtN6BbWMBbWYg9kxIJChPk9sRfJtHodazwIlCJ0BuJLXKdS9RN3xqWj7bL3AIQmN5IPEtsMms+cTyCIoOhPIIN49jvyiJFzkGQIDeeL3zB7DidJOotyQppCkM4zIwKvviy3bjo35adQ+rzRJmASHMEznQVv0/eNsICVvA9j6sGxFgo5dMIg0ZzQgnD9AOThl+1DrtXozreOzWGdQH4CEqB0DZHBCPU9oSsP/FDdsQrnrDC6pRsEGd3mm+Bm7tc2xXxmQ3vY/A68v3uzOQAp8idffuR7+FU9SvlCvPSPYttKr0lkhirqBlPLrb86ECOTXAi+WcgO3yrniBmfUjvjbm583M9kShwnXQPKVGF0kk/tHdRPftKjoGOL0jd/zo1RJxoGbC00tNE7wnKtWQFF8+nWg77bHoO+U3X8MHd1XlDP4v/rmNuZObBIGT/R1FFdYxR8uggsXzFDgK4pIw99qCsZYSlCNWmdEugtj8ZYaay1kzjLpYtm+humCsRj9INmX925bPVGM0hnJsUedSVeH8rqPQPkSXOOfQd7VcnLdkZ0GSxZOEHitL7oMnZCAFmLiTu3/KcbS4nhBpuDSE5Fc8ZXeFg/qZsD1lcV2zN1LYvccYw=
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