/2ACwT6XSmstsxGmQXE/Qrncve1arEOlq2oTYzk2nIrx8/QRDyf4PuJFn8anUfNiBUm8WXYiE4nAtUa1+vVMUe9Kk2xeEvMjDHr25y0Va4pucCcRUCorhM6BoM3xZVr7iAJkeVNZskY3GnesrC9s/jTrR+ZLveii3HdldAmNrHS4wHc17bvKmJXozWKk/xuM3K1kgKQ8jvHBCMZU7BrOqs6pi6goSQLv004LpTjsymAD9v/WhCfWDS2ph/FNXLYM94HFow9tldO6xSrFHAOMT6s89UKi8yUAbw2cpJYKdl43+zmX+1Cb+ipQ1pxHA0sJ+dKZc+0L7JjN9pvLxq78zwD2fXhBPadH23UYv/5lM3BySZnNLt4B4czqbWone0oixcQ5GTlrPmEvMUBdZUn+LQ7MJFPlWmRUZg+5f7kFPhsKkx0ysujRBGQjXzzUu13QfTDNY8akYMNNqPlwth1lCwpL0mAFMxSlm3GNQyAiPftb4RTQ9mPS+uQiV9pQJen9cld7OBCLM2+M5NufWXCCWbT6Kc719uR0Dn3WwZwgyL9A78A8VtL3m5oIPt1v8XSjElVeLNjx2fRL8hlEDlR9TFCkIPMFfDfxMIugzp70YNa+YvoH1BbEsmezNnAK07WjtJjmvRVes6+hpy3wPo4IiZN6H2H5kLspKwfQXrdiBwSfT7gbEL1/w2M0QMpaKl8wW1d+JHQROI16d2yFvXU/Klx3h3rwxcTgaheux8YEvJmjEMZxkmzw6CpbYtkc5NRCWKhYmSaeoVsB6KIFRzXFYr3Ky8oFNU2esuYXFgVvcdcD4AJfRwVXNaV6HZfr0u2zppn/QpSQ0lyCUxnC5pKhimsFfxR2zosQKKk7tUVo26ThkW6h5WWID6LP968VumfFcRTYzM4KNWN/BSkG5g6aRYeoh94q/QqnpOlfQ0XksPg8Wo4uDthw5cXKnHozB7BJYigT3sfO3YkaheGO04kFz01X8Yt4If6LHTQrcDt+d5rdhdeQYe5+f4HvQV4s5ewtcxyIrX/QfKuxJiwjXHsKbcuF+0z1bhKJ35SJyq7l7J+NRnr5wByNNskU3RyYFpYRBhwAryHNmVmBtbJYEZ5rfmNBzOP5B80iwFQkEcWjURq35viKG+kWdLEIe0fi2LsF89qk8DV8LfMnfqZDhvcm3ROTZlVeIYOejUxbNH7bxLjUbkz/JBb7D6Cu9u4DKIbIWUrKsSqztwGF1bniKIIzA2AM6wMfArlBDT/2jva43zAfN+niviDq97Xb+DF0xdAgB2//N4yC4fGEbaUO9xkprsDp+urvMKcajS7p5wqJoU/sdIXDcCMJ0fEZGTBpL4DWWZfTH68leoMzYSjC6N6UEBc1YXOBnmRUPMNxNN8=
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