UHREaQOK6rNI+SKg8iioZk3dqrKveH+W0kWX6joBPtl6aFLMUUMlxCrAgVi5OGZsfjPGyuZuDNDA6r5CIdjwzeQXfKiOyQiW9gfGIiF3tXnMp2J/Ag021MvDNlDjClzUv7CCSX1HMJjF9GGDkmT2Xhyal3ZMGnx15ktDDTVvAXkYIUZJPd6lFrYNnAqIDbPys6AehY3xbHsRUU117+O4NFsJII5YNtVVJMmVnodN0YNuStP8NJbvoOWajEmRm2mDTaBWZzKE7wtvrHAhkGIzkPHxabtIp7TA6hgqC7d3moaZ4NHkipDGJLKwKsx5E4xR4zQYcV+gfyq9NsrA9ESzWRYHSxvWK3KakFGqQlv3ddcLbcZ1SSpZ6vpKgswmp/njGGgwAunDThAR+uB5qYccj2mP8yj3nViURCsu5e8NYUyPRT92Y9CEw3eFr7aNCbKBoSNsWDU1mxKkX1Pd9K2SdjQ4T862HIECnGqLF0TbECTT7p7yqzjSBMz5/JO87/96gXWhvK6yZ2IGabpdsK9uBlUTAPhR+EiwisCd3kZ26dYxg8ggClXbMLJQDbL5sUlsdAvmADJafDJP5wR76xveUZJSTCF2tXS332iYPsBFoir8F92F7pWohFSddaoDl111BcCuPNjmm3j6y/TV6UoYqq+clxvgXfFHipPyWaLC8Mu0mj9+pQpgS5QydcLH+ayAXPKKRRk3S2SyegY7mfL8IoqF/o/dnJne8rw48Urnre+2ToGfHjvu8YbL6PDxMRpiVWELtUVxRSi59g3mTMczSCZ4pxoWd8z79GG+QbRyihdJ6DqUtFnzsJxTip1lpwUZDT/VcJHpG41Oq4Ec4m3M6MaUkZYebKq3aPCmWJpRr2KBGVJKWq85Jty5KwnQEfGTSvhFc8xkYytp/TPe5Dnwlh2VpQ9T4KpC20rS8pgRsLEo+UpTn6t4G4T7GXT4+MNYAzZaD62zioiRYqcBaU8dZ5S9ZHzHKyqYCFHozp6J7ieeYlM1iybIpHqY1VS2DOo7sMMQaZBGvU3ufOSTVmv2uoUO+tYOu9NVmpCgnkKBQscvlQRi3xzhyyQxPBLPhmEZAf4i9Q9bObVK0OMHzA0CV51qyn5ZS+BdEyFPhveNTnXbPdK14E5S18IMzT1bxyL3kFxo1z154n5QSG1dnRXO3+toXb4FxsJKnn6s6HNmtX9l5pR0Li9eNGPcsmadj8DHSNcVz/7UfVJ3QPM/aAiGGQnQXtZk4jlPAyJfDQvqIP2q+X+PpxPuT+Ay4eDN2yZjTslhX7UDOi+y1BghDMaMVuwOjF7Pu1y2IfeNkpfXP95mWLFZxBh+IJkgAzC82wUzOc7cdGti39Bv5HlI4SqYB8Yo0u05UHSX7DWvgZk=
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