2pQ+NdYVx4ckc6PxnnQG4Ogs7WXfpXmha63qX0WMS8E3psunxVymVqCQRxZ3a0TSOgp/sPzp4unfg2ECX29gq8w1+PtpGeOJNwhWadUKjBvVEHiEF4eDVUc/9Er999SAZitvaagpsek7o2wLfKC1+ghM5W+JVdGwYSJnfjSZw3Zu5anZPuxPAJhbj/aQiz5TmuF2DfEI150h/dnOk2fFl4f+VIHRvY6xA0cvzGd7//uAaDBfDEIQqxFeohnsLVh9pzLVQsXFiGCPmA4T4a/1j09amor4O8EI2XjbqXXPL9sbhjtIG7rF3NQwQYQmW6QSV9A6H6rfTd0wBF/XyKGihCFJ6tc7qGHKy/4j5+Tees2SYUWobffP2RilFaXuT5T1blp39uYXlLbMU59MlYf81d3MDLBcSFwxIMzDzZ3GQPUI1I/jWe2TaceKoIdBbYe0i1Ef5VyfPKMJs2z8xqJkszI+P33HabmnBJaf+22cqgKwBNRk2KvngAxSl5FP3VlXJvmW39qycNrlBWL6o2D/3jNCqWEVMZJMiJ+u2ugkWWCKAGbeorvXGY6xgh9uvFrltP4YdUvd8Cw+Z88h5pykej4RoAxqfqs2pQGjxHF9K420eefOX/p25Et+Z8AvM8V5SvUIcgGshOw6EobA5ZJ6hN/wWlNn7aUr6fzqLfXVRb+1kw15u2MEBTbAWR7j/cgEPg26T0qqSxTT3ahhGUYN6Vj5Mz206n9GBxujPTGOSJDNVXtUBzRp2+sII5M9rE4+DFoWFdL4scmmaOF+s2y+KMyOYjkJzj8Ku1ZsDqWpHOGrqIz3XKs4iIEU4jAQWxhVtv3KUKf5hv2mQmmq8/zjw4GIa3JNniJEd8BZsfrHAQk+9S/zA6NzPklSJOEqmlyHsESDA9udkyTjflFmQeiKn/tCcU2qFTw243tpNjbTjmQU2A6Xv/3yjOraulBQNj9EoafimWWs4HbsSgVZersqEYjUMVNc9OVhkDqTnZVgb0XjP6VKhp2pNKaBjH/qKKMHiqhlJNAhylN1etbuc0Z9icJFRXpSUGXZ25L/BN4xOfWSgNCpqfqaM8j0tFlolyz1oarV+/hj/xzpJ1GxagVY4pOvc9gVuY8PFMhI8dyqY2QS0oGoP+1dK4LNJLUUHPokICDjRkOrY7/lfmvgJjCG+jKHUwUI0IHsSd20yIDgURsZg17notUnzlx48+yV/S2YQfJ+s6dNRw2IM58uYtPN+amIFFuUcoHhSIt0TwwD9MFNLItIhV0Nm7L1QR6jAEV1lHsho1xHCxd8Y5a0LHF2xHIe6qRON3vpw4USepgMin1r9Cf5rFj/Zl0TWxzdicRy7QZ2DyNE+SyulpZ01kEqpW7ML3ksG34MImC/ZmQ=
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