UyiUhBVkFmH9FZgt6fKzxYluxVvY+Z3ojtk8xQDeEiEKuPRRiULO76/c+N28mDLKKfdQlzLPHB5fnojUVbDPTDge9FrTO/38ZUf7D/wkcEPi2mRYSwVYaae3D9k7BCwnz9NlkKePgJR0MXJoMPrcCxiKNiQrmxQaw7C3khg9L9uy691vVqHEvnmwuKUHwJprU+R34czabt7dmvjPxvV6nMw0W8HtYmeZyjFqImAdRC0Qi7zliTRlpL5abcG6giQynjpiBDAz22KiZpRSrLGXJvBQNYbF8OCEMXgGOt5mZrgxhb1oppeNAIW1HHkaM7YwMKCiu5eqvepBd16t3/9mvNhxh8gyr/7MUGsrjIYha1a/IIrCL1xkyTYctaJYqGRj5wIK7NXpOctUirJrENAwvRQI/uryxXYYaXeZ5+kF6zPCcERsxH2rxMK+zSnXANDxuEzdlnhIBm9lXNn2ula6FJD8BLSUkUOfzJYcgdUQAKKdxDjxgvM2ReVBiSGtG5FR7Va+WTBkQBHDn/bGL9/YbaI9XIORK1B0TWUJYGyZcMKGPp7lfTMIKbel/NLz+7afxPoGa3KzI1MhmiX3lyCE6gKjrnAeGMK5k5H5vw2rKkG+Kykm11SRTEUHELGxSjPQ10t3HCZdNHK5bVlu7AaNUy0BYP3IgV0tdUN3Xzm+R1CPamyZxjQkUy8NSCBtPkYhCQQ+cqtmif2NXvO27lGDYfuOO/RGrRj66wDLoa9K2p1wGDlMygw6IdS02o47gSsw10/xDH3qdOFJ0VUfkCmcMjbxBku/+wTjxMiZcikyuxufVNMWMa6RVyUHakwONYZEp6JJmO8PO21f7DJdtv2CqwTfnbfK8hWBnPxB8DI6guCBRif8WGRlUC7ZkDLzq4skujwmiZlAjStl/fvCBWErUqputGcM+Sx+V1dcCX7T6qfLmqdNigT6bRP5J966DR84e7A8j7v2ZpIRypVaoXT/boozW0TGoqNlrLoVD6FLGaGITp69mqQxCTCnX6UrakaQysjxidhihnpbpn2ZdfMdf67vqUajO7z2xch1auutCKYAEhR1lR9mJnKAqSeGncuaTP6ztpxXAR4kg94pfdbKMbwMxLm2nQDo8KFFMeUr4+g4+96R8ZBlmdDRHRCsKdOdZ8BIfx96BmY6uJPvkhH2tUOv/8ocsVf29d+OH+p7Lii5NEJsLzsCNWP5V14YB7CjR2tKfev6Am8HcEGfh4DSX2IgHS0w0QbxHQRxCB1V50dWKIKt7jX72Eb8n1O9qXpI+sHfRyDd0s5GhUIfyPCR5N79ajS9lnyiSEP6C5gUjznDQCutKr3d5o68PidfsUt+xPZpsl/Lvkw9zklxZyqBTid6MW5/5Be1iRH3Apr7dVfhv8qTZy4IS7XWS0EiDkG5ZBjrtEXfQs9EfXJLS8QWcj8hnQXJNVrVzooBFSJ5NFVWBxtCQxvKQMs2QPh8ugL/5IIJnjeqVl59FJwF4f1aSl4rCdO2/3ndf4LxZt5yCeJXZVH5rXHug6jtFb+Dzsm5cf8PNcyF1JHfHpRMxDM+6mFrAQmJMk/7YzvFcQ55DveYbZcsthuawxarGivXQQJLJ3xrNOXZAY0MJyuyTt7XlGFY+U31DOB7ooUZSMARbYcXfctK4lOn04Qv0YPgZRrxBenlmCgtHNZ7qJH5iW8Hr/n9E2gIgpAfKsrCIaQ1yM9cBGdSi/Om/QgRrEU=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100