2NUKFbn3hgEY9h/fCShJPlByZ8v580OKs2XEoWxbdPaoHX6ZTF9mWj9bdM2ShrPq9lYpANPKPuNcyNSSXXsdcFBunmjk1FNwaMFVlYK9SNrzrLpSD8FVPvvRvEaeDJ+lwiHckBJ+AgZqRLHVjHvWeCzFVedZGgHQjSZbXLsFurLgZyGRA1KDqzU8DHeE4Hseb63dA54H5kUobCN3Q1X1pl2ssXkTSNvZj8E8r6DQ14GPZH5Ea3Xs9jc9ViK6I5+TfI2Eo8e2jnB1STjxQWxsKFBMztufHou2/4zzuFR8qYU9YaiZulItLLZm1w/j8E7NYTveu1HdSotd0KXRV8ieT55vK/f8dUgO5hQfB3sZiVM4bciXyhqgQldK/8mrdM5UHfGjKuVB0utkskhugZ8d8kwspX8e4LOp3faH3mHYYFhpuo+4Kt7EWj+NZ6OdZor7jvIrISngLllJyqRpO3w63np7HgqCffolkHE5/M6xW7a/JdFhxpRkreNq0R6Wfxo+GprxNP99JjG/TTbMTHyRvr9gdQk9sNYOn9zcH+pFeamxT95i/J8fAVvTwZgnU6KXWjtHKUB2HiAlgRsKCRkgvwOqjfnLu8qrW8cehb3uksPgh9osUN69MUyvjJL97etbaahaQyetNBHT3GAetu/cE9xxEsYOMIRKiu9tLnQ+gxgaE6joyjST7OLQ+pQxzV9fKRkufht2TM79ewoSdUCN6yuFq5C138Axv1oZm9g+Ggubm982eWSk5hfz+4fDTSMdssAh6APC5vcL12d0J2jJ2pIV5ixGzIj5JNW5t/rFb2iqJpsYa6ffz7Ls7g2jZEOD4SLEp9yy2feh05tXWsZ41qBaUC43d/IyQy6KqZIr+5l01wgeCSk/dtzD2RAxduxR8Tvo7qtNrFs8NuQ2M9co5q3zDr5PDobTs2CFtShI6rjYtxTldh9z2HMFbodfMON8SusB3DAgb02MoiMjuQD3MOu+G7ORqVSO2D+hUc5oSi0Oli20btQQg/bYkJRNNY1QIt/zT7RUDVBDWXMhkm7p33I5Cs8HsZXWx3lj4xEnbe/P4+4KmWm5YBj+J440pSSDcASil7Yvs8wL8ZVolvR8SQPWj3+Kp7c7Fx/EfJnQ5io3MENJwXa/kNOmkvZZwDtj82mbiUd3pRuq9M76IYytSmgSH8XfRpDVBILB9oWwuOgAZ77uho5yZ+wWLDm8vYWubsKQHVaJIVvLRoq1thgrhWNgXTU6GcQVodWWIYaHqO9AEDRXIXXfygYJoLrq1IJwn8aiJaV7SiIN8ijwO3oaavSVimWzAnSXrTYM04IjQtCMdlHMWEJ2jQbCsONyl5HhXw64tKErpIT4hXgNuJRCgzL8/IL8CFsW+zFzunQ=
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