Fixed repositioning so that it now uses conditionsHash, implemented skipHardLimitOnQueries on select which was necessary to make ranges actually work