LBjmUhWQJT7ydd6+06fpQ3tBkVp0CGcQShRRmsXo2oU6K1TntcpODoAND7AKUMCus2JhoZHTPrQdLAAVoMJbR9OWr5Hrd6UQ1hZX3OR1AY+gkuEK3JOGRXuP4WiI54cX5r/jkaY4jboIqYtUjD/xEyIPcxIv5iuws2UfMJhaDFQXD8ra9Mv6ldX8wLLvSBDujVS81aCqNPRtcrFmzXxb7euj1KkeTqZMVlN6cuiFwkIvBtt3w6oaTzE75r3u6kI7kIi4Xin8Ip3csgRL90Y0brZ7ChQpWOeX80InwFQKk8dz+uzrkiaTYc7LQgOz6A/jEWt+ca0+X78Bm79W2cu60txpMGRAXFhRs436s2MKR1JXdA2GtJwFd6KHRGqIY/ms7DAPV6sB/CaWQ6XBUEjvmnyOTRRQIBjVt4Z5j5RWti2LfB7elJuocaaZtFtULkDJFhSZKYjIlB3I+t5QU1bhvwwg0zHG30yVWP1vkAlI+5PPl3K9PxWV1PT9vzbGIfgHhYnsRtNk5dLGIRZcYp29ewY3TLuApRlbezgiYCOWD5SK5UmsGnI4dWYHv9IjINmTce8p6pIkEZYsOTERtJmncnPwAlGmLSmKk0hk9tOaW4NEM/8AKtMpHllIoaT/kBqPGOkxS0OcIkm4ZifK9tp8oruCLA8ssV/nHJ9AUIeAETeu6KoPWLE4VVSXtBjg/JHhv3BTFqie7g6Es5WXaEyqyn+KrUBpVx9XSQVwSt2bUyUFpM+Ju2WX5tMfOGKA4OZlzuYCeub93yOcFmWdBrhy6T1zu0vHF6ysbVuDxC1a/vghoCNzs3Xj/g0ZxKJH/M+pxmVPRXTrG6e/6FY0h6svxZ9Y/NdmRF1MpJXFI7z9MjdEGgIKd1ovohmrcKGluzzfoQsqowmWFHSLw7RNNGRvpv5YL6JUWToY0c1kLJXwOJMdFH5snL5/i/Vp4yJRF3FP70ohzbKfWzsHHT2BsNmtx4hcZ4+mM+7d+2GrlgE9ejD3zKgGHtrNpmjOKsHsUlzz6DCr1Y9Tm8oj9/Hj4Z5KbApPrix+I451hriqRivJ3S1Aq9LonY8D8rnH0fgAScgkPC57uAT3/E+Si4jPEIQFlLbV45eZAvoAOwI6avWF6mXMZkj80pCU/kb1IpMkMaT/S7UOvLtEv3V8cf6Dt3ga24M5o17QLAqSeSSVi+aenBgd2+yUSR6RRcDa1imBAOQPEOnaburzUarG/ndggE+18G5y6YuIY67ebr+kELH3rb2PGCQbpBcw1HbyVm2lfUAhee+JibY4GTJ3Te6tJFhNDvOykuMD0OEMpW6uh/E1GCVbXnG1oO3IXTDbcxBKoAqdzfHfVSA3ow+cTCAHPKDXFTl7LOHQdgoYCcGpqTk=
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