BIodquhaEMXWnxQ+fUfYkNljp4/MHnTssfzWyj4SxgwpXx3bmVr3PS86/n7d++hcQtYJsVCjBjmmx6wCnC8YDFSITGbunLlG0XDgU5xDj92fGYKt+1TZP30C70ZWv7L18Yw9oQStPvod6KVtbzgBVMWdKXJ2B8l/sAO8PiO3HNSbpo9NAncmoAhpOrnMWupeDSz6fYZTt4JATPJVfeJ6gpA7P7JhwYcDJwy089FPwdGxDQA9OyGEPJPoYSdRiQd1QcaS+lcbqEBKxMYfedvLUr4Pl4ZeLScyfHeZewiepdZmMRCz9rqyLtPqseqlJNlZoIDJ2VPr+0BYGqc5VwyqTGbmdWYcxziUMVD9AeUx1NeeeGsKANOyyUlsJ+P8j7TpWiEEzRQIieZSfbM1N3W1SAjJnw3fgOUItXduY7gzNhzWqb32hGgN++ytwSQg1oIQdVQrx40MFVdAHCy4EDHoVQBYNsMAWU278IThR3u9b3FHEhpjsfEBNAHJZXuzPN1uiPZ5XOWqolBFSYDbzIzl9+fn71IKACzKJUg356PAgBkaGLtP4EwXnwzJzXfybUtEsAyoEX8nUcgyty+calnFvblJNJ/CEqPMxtn6I5j9x1TFvNHnNMIGcmhS1waJOdCvgJ2mAaiRd2x24/3ZIvNxpqTCwZlF0uKBsHy3AOgqKwa4jQmOMi68axHKKFYPI6myCGlVDG//YF3LTgkJPuxQ9JYhlgDU+ux8q5I2PRhusAG4mDQfNcx1rCk9UWnt++5dnioyUBNsiTa1uf43ynMhUXgxGcnP+9E3DIYJxDzOy2i7XA690IJ9SUlj+T/CepukS0/tvgzXVp/zhb4+Gm6yGgVc4GyaRv1PK3RVMHRN2xmHiKLb0oMybgpoG2Bj9iNFMHTjNl6QbITCsSM17Zx98fghQm62VniD8A9Po6+5+LalQ1BtsJgpyHc27GQwM99vOc6XWoZHU3HznLvzTN3A+H6+hQWXzZDB7k7e08F1IvLQ0rjEDctfJZhLXHZvfeF5WO6iWpNtpI1iPultRvuMTRpiUpgmbF68RksRO4CjhtzP19T+wqEBe/kSe7eSEa2O21oGL9kokqf0HsxExkoi+fTYQAc5XnGtvX8Nc6CrZ9wH0lzbBRaYB7PcXID0pXqUNopEeeRLsn1UZqv2DfNgU8H3h9bvRqtU9JpjQ+Pto2wImIYdDxSCy2kvoWY81DU+Q4iGjHC/1XZyZbiCtU9BmRJhAvp0pj+GepH+tZQtonRlPl0tbSOzEm0Mq9q3ulUUDYoCg98n8r8y0R+D3KkfAxM5nStzFGtGUXGh5XOeYkk606ImV4AnVwymG7tG1pLX1SjnEee7c/rdxjrUKbnGJeggJAS9sci61eEOvcI=
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