nMRCJxHxNxPQ7uE7X6pm/VKjA3gWxkYaG1I7b0alLTbDgMNIpSNcSZEm3sPU/rzswvGVCVOqG76qGZdkDKUgUdg9mPMYf10RsvSOvr0xU/TYC58JUUvnprg7d+FXczf5FB7e2NBWStSQWLVnRP/06L6Bg06rtM5IzW3JeGFCcd7O6bFcEGrmvV6iWk0rrzAJ584U/F9YC5PxehkWYK35C64B13Qx/K3u59KJs+BTeOYn4KGVObWhDSuZInrW0I7hg+D+vr9spf5vc5u0Tu0oRHbUkVsYuMU6UyoJYe4DC8SUyeG4pl3GhCfWRc36Lwbpool3bc79sjtwzlpjnW3RgqDJRMVJOmWBsdahOZnIN4ufEBuu4pTGJ7p0aCKsd+Fjr7Sm4+uj8nWd2mVsuT0Rc6eEPdiEdWm/H1o2jV+DYFIr8UBIFttNz10HI8bBFl2WI7URFBBpP0TKyZin3z85xiSny92QLrvLOLdC+WbFYCQpY2tPXodyaUQoYdka3Jj7DrjqDcRtUcwd1pZHkX5l0qOm90MslYw55+XgrV9WaKzPdhwTROUA+GQM5Y0r0IdWJlEwFdl7rAp6gDy0rBW9MD8wJtBKVoAqiWtqnnUUByb3pfYoi1lMjFJzZOuemkfKm7l9Nf/plpE78LIouNUVmlY7jvM6HC6LS02r+DGnNTxMDASJoFSQ0PxSc+asF0QZvBH4oYO2ZpaNdboPsbNLMO95cmWep3aZhsx3T3XpNtQjJasmDt2vnpC2k0+mM+rBYLXz7zVLhlk5z3bTsFbJnVwOn2Sw4nd6+ZATtPdpZFBtIomOH7NWY2hETNRB/9NWt/uSrAoOHz2KppETUXiwqV1iXNc3rck26EiGU7BcKIXVzHzZhh+Sl0p+SLIqqkDZBAz8mvxHmG91BJnJe5xLGrSHCnkT7sLAPcCqRkaNVsi2jzeMVUfAys9aevw9HoN34tatrF7malzNtoJVqOjUt8+iF5TW8EtmfxzI9Df1OnPfticA4ZcDMBggjDCsOWVNsHy/jF25gL1zMEaLq8P2j2HYsGuvMp4eHURMCVyc183OSK/FK9XIBfGVTKlGdSLxlZRdKd+h7/68i/IPCok++0wMu09dyftEFT3iS+4dScMPGQ8EZJ4BIkkyzgZ1kUjaz04yRiOtzmHurGYACpImM//7ttEgdXqD7DsuWFK6VWtoqnXDNUmF0O61GbGzyb6gJ5YNaEWcX2Rkpc494G/y6ndytaJKawoyH4p3xveTHNtkhDbg7WaVO1Gk9g9H5YRhp3velLDzbHg2hEe8Ed9tkA8pGskN9UxN4DJ2cp8Z8jgq52UOvHOnersX2K2IuKsdPMx9PZgoInvnVc9a7dmnw/vAaIfcp2/jaF6T4/A=
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