fix offset-condition select + upgrade backend