OIPjUBAKX57Kdev+nVjckydg1YmOUAyFdtxIDpT2GlITpNmQXuBJ4Mt7Fq1Z+4ns8n0T+JVqF6tIntf4vAwA/DYlpLGVbgYeLhPSbcUZ3+fPG4CoXZ34mEEC+4/PyBPQRendsQMvW9MPAA3dGruqyIVh6qe8lamD0+fRjsptrA5gbblXOlCLYtGgwQ3Bksa0BnjFA43mT/MVjQXsxF/FpgsrOvfnKLJkrjqhZJXOi+866aCRJ3opZyWxQZIchdyywNqjxvR+h9O+TkfTg7saWWwlp8wLcBa6XdZkJKOUQyD1Z7Igwjxnql3d+wDO3qu4n/l09MTiOj1cmXQQO1bclYX5bv6fwoP7/XZMdKHVY6N5mSyGUg/FrWvoenCp3Ni9ydLIxoz4WWDm67aJwmRr2hyxqY7H2gcbMC0EFqSTXqwFVMIjZ+/ouSxhraxeYKQBqnleAt1BgrK1U3dXYT1R/mIB3R4CIVb/y2I/vCRfrHivnixBW8smA74flOGDy8ZomiS5DJ0pua46gBkOE329SCcRWvnwx1Y9GA2GVLdCH84p9ewZpipQbcY/0k9ntrVkI9Hsaf+Ejj4vrO+A1czdRO5aQvWH5vm7vOngu8I9FgbOH4KJIYiFlCHOkpG4m1YCDK9rtVhU6zpAIad2fOpCekO0v9bd3p+Od/ERJYtcNpyNSQ8xI+u1bWe7a3e65aCVmDBBXbGDDM13d1hxHhlOOSxfkDDD+vGoXP8/14sDaWDegQaIUJFdtltiC+X0/cU5C9/E2v3ygKVJOMbJC/EJIxmKa9J8wH0Kp/Zug3JJKCFt7dN0HIaNBNzLHyWTnCghaPfgwLNH2Cuzd4Z+59XeFIqYuSs8D2QLeHL+kUW6krbXQ7UE9RGE4DKyHAMXUjUV37zE2tkilXaOc6YZvB+CtkFjFoukczKLWohf3+i+VoMStVGNGZ8SPym+Gw01t5kmN14LO8lqc8/+/jq+g1N2NTTJAmX4Ipdy8AKOwGUxTyb7VBwJSPCyjk6qVMjHmfbLgXT0YKgtNdjHkdtB8me0SyK/yBV5meTSGPXFJuQhb6ZG0B7YB6kTZWrQXTSpt+4daY/om1sci+Aj0poKy6+a3FMu6dak8MJLzs57cvNXw3GrzYZeQuwTyFqhJtUOOqUxTBNyY83mnhx4PVIvxaVt6L4HW54wp7NmhGYC0rgfmTeQ2sY4pzN4DWkoSbMEbB5RZP5Ha015V8wVqB7j1VIAdBHZw30PwvQ7bv33Nu1nMPmMwQmAteOqyZBEf0CbINcTmlKKCQiyYWZqfGmgEaE6LHq0pBFBxGRoYjf6sHXKy5qOEt/gZncM98prrDQuxQ7rj796beggRlAYvf0qjZ5BDE8tx1Dyq43kEZ674No=
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