mVTAvhtsLreuFSpsXhG7o0DKK1kIp4+Mreofz6CN0g2zULenswRNJYTFYNhb1+bl2/r03g8UW53L+tfb0ZDgJuzbOcV49zD3tWyu4Ycr71rmGmFoWWbl8CDftOmUMCW9zve6kVr24NeRxtIJb1JbFfG5Stuikxr/Vg65lgVxPfGiThNzuH1vVgz4w00D7RkPhN8MvbofDQJ5zwFYDOG7jJVEfWtQL1p4Xwp+tjfWjgW2/WncQ5bjZPolurrDebeBn8QmCvra4LrhsE519N0dFbJSqJuMoKiYVPF6inBr/aqD8g14JchTvOZLE6HiXujk1dGKzet3HF5lWYz7cWJrSD60+cn7chhSFE4hsdbdhOzBLmqhJ0zMUM5QJxvOK3L0XaMsWOdlwJYhU4fj8apfWns4x9tvDVx3Wup5G7rnvbcehA0/+u90n6tK1ahlB6YZRkyb8en87lnLiD8W8fg8xsPWkE04iWecE7PPXjIcY3QCoicdwEqNoMjRU+5GBCnvrxRHgjjD2Xmw22mb5dEST4t7dUHCfST7C1Cge2ab/8gXr1gfte0cKeUAoA3BZXeSfvqSFhTV0H1Unom+IUHJ7l6pWJUd93HMqpjBVBvEncCRB0e5uvEos80ec52gCx97K/lVG3w7CSoVfNlwS0MIdg2ervhE/zIi88V1jD35f4qPueHcfkefXAtZUwOmT3W46YEeYLRfP30H61stHGOXd0uv6IRZQPFwCxkJ7INBC9iKMNf7PWD6VzU0GgvQPa5euMU86uyvJc9x1gbU96RWcDdwSNQHUSfGndPHlFJ+AgaACOiiKx4MsSvGkBru0sYoMrHuYTXj5nU9+IMGqgxa6OJqyp0oz7gDrnwbbNTeMCoYHqHD3ZSDYklHYE2s31uUp7oBzhubLk3BEf2gKFJ6r99aG0HgJzlzrx18GJfTCbr9m8zKn8lxm17IFdN3J2aCzCTB6W+Pm2d28dpfoqihfPnJKoqo1MJ5EqaH7NYo3yw9E56YoX/pdElftUYcl664ttB5VoCiESrwGFXYjvuB112nDK19Nb7M26QJWjArexebRhOjVS3WeWw7Aj0Pppon5fKQfQ3AR6/ufPcxv+RnpiquvkF6a9oUBQejfdCy0h1Wfe2M1dSHfcfvgX4Yn99rb4vdNRBQ8xbRj8YIFOzpK0gmi09BxKtv7+xTeuVPNo514LyifVMnJvugewow7NesnyZz28NXg5vV3X/d0eKfVY2sfMtq4XLVQmz/EIxMTH8yz5pjLBx1ZohLaufdBQVpJ1Q/RWHHb1IKB2rpVPokx5ePL9HvsFOdWR7To0gvHAfA0I1sJ3MRZ9pyOACiinhu+GjYWK7E9Nvp9h08tKCwVZEnTa94dvlZBliqMQk=
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